一键在 Manus 中运行任何 Skill

$pwd:

power-bi-visuals

Name: Power Bi Visuals
Author: MinaSaad1

// Add, configure, bind data to, and bulk-manage visuals on Power BI PBIR report pages using pbi-cli. Invoke this skill whenever the user mentions "add a chart", "bar chart", "line chart", "card", "KPI", "gauge", "scatter", "table visual", "matrix", "slicer", "combo chart", "bind data", "visual type", "visual layout", "resize visuals", "bulk update visuals", "bulk delete", "visual calculations", or wants to place, move, bind, or remove any visual on a report page. Also invoke when the user asks what visual types are supported or how to connect a visual to their data model.

在 Manus 中运行

$ git log --oneline --stat

stars:342

forks:99

updated:2026年5月16日 11:41

SKILL.md

readonly

related-skills.json

同仓库

power-bi-report.md

from "MinaSaad1/pbi-cli"

Scaffold, validate, preview, and manage Power BI PBIR report projects using pbi-cli. Invoke this skill whenever the user mentions "create report", "new report", "PBIR", "scaffold", "validate report", "report structure", "preview report", "report info", "reload Desktop", "convert report", ".pbip project", "report project", or wants to understand the PBIR folder format, set up a new report from scratch, or work with the report as a whole. For specific tasks, see also: power-bi-visuals (charts, binding), power-bi-pages (page management), power-bi-themes (themes, formatting), power-bi-filters (page/visual filters).

2026-05-16342

power-bi-themes.md

from "MinaSaad1/pbi-cli"

Apply, inspect, and compare Power BI report themes and conditional formatting rules using pbi-cli. Invoke this skill whenever the user mentions "theme", "colours", "colors", "branding", "dark mode", "corporate theme", "styling", "conditional formatting", "colour scale", "gradient", "data bars", "background colour", "formatting rules", "visual formatting", or wants to change the overall look-and-feel of a report or apply data-driven formatting to specific visuals.

2026-05-08342

power-bi-custom-visuals.md

from "MinaSaad1/pbi-cli"

Vibe-code Power BI custom visuals end-to-end: scaffold a TypeScript project, iterate on src/visual.ts and capabilities.json, validate with the Power BI Visuals SDK toolchain, package to .pbiviz, and import into a PBIR report. Invoke this skill whenever the user mentions "custom visual", "pbiviz", "powerbi-visuals-tools", "IVisual", "build a chart Power BI doesn't have", "developer visual", or wants a custom-built visual that the built-in Power BI library can't render. NOT for: changing colors / themes (use Power BI Themes), adding built-in visuals like bar/line/card/table (use Power BI Visuals), or modifying the data model.

2026-05-04342

power-bi-filters.md

from "MinaSaad1/pbi-cli"

Add, remove, and manage page-level and visual-level filters on Power BI PBIR reports using pbi-cli. Invoke this skill whenever the user mentions "filter", "TopN filter", "top 10", "bottom 5", "relative date filter", "last 30 days", "categorical filter", "include values", "exclude values", "clear filters", "slicer filter", "page filter", "visual filter", or wants to restrict which data appears on a page or in a specific visual.

2026-04-07342

power-bi-pages.md

from "MinaSaad1/pbi-cli"

Manage Power BI report pages and bookmarks -- add, remove, configure, and lay out pages in PBIR reports using pbi-cli. Invoke this skill whenever the user mentions "add page", "new page", "delete page", "page layout", "page size", "page background", "hide page", "show page", "drillthrough", "page order", "page visibility", "page settings", "page navigation", "bookmark", "create bookmark", "save bookmark", "delete bookmark", or wants to manage bookmarks that capture page-level state. Also invoke when the user asks about drillthrough configuration or pageBinding.

2026-04-07342

power-bi-dax.md

from "MinaSaad1/pbi-cli"

Write, execute, and optimize DAX queries and measures for Power BI semantic models using pbi-cli. Invoke this skill whenever the user mentions DAX, queries data in Power BI, writes calculations, creates measures, asks about EVALUATE, SUMMARIZECOLUMNS, CALCULATE, time intelligence, or wants to analyze/aggregate data from a semantic model. Also invoke when the user asks to run a query, test a formula, or check row counts. This skill contains critical guidance on passing DAX expressions via CLI arguments -- multi-line DAX (VAR/RETURN) requires special handling.

2026-04-05342

package.json

"author": "MinaSaad1"

"repository": "MinaSaad1/pbi-cli"

打开 GitHub 仓库查看创作者相关仓库

$ install --global

$ download --local

在 Manus 中运行

$ useful --forSOC

软件开发工程师计算机与数学类职业15-1252L4

name	Power BI Visuals
description	Add, configure, bind data to, and bulk-manage visuals on Power BI PBIR report pages using pbi-cli. Invoke this skill whenever the user mentions "add a chart", "bar chart", "line chart", "card", "KPI", "gauge", "scatter", "table visual", "matrix", "slicer", "combo chart", "bind data", "visual type", "visual layout", "resize visuals", "bulk update visuals", "bulk delete", "visual calculations", or wants to place, move, bind, or remove any visual on a report page. Also invoke when the user asks what visual types are supported or how to connect a visual to their data model.
tools	pbi-cli

Power BI Visuals Skill

Create and manage visuals on PBIR report pages. No Power BI Desktop connection is needed -- these commands operate directly on JSON files.

Adding Visuals

# Add by alias (pbi-cli resolves to the PBIR type)
pbi visual add --page page_abc123 --type bar
pbi visual add --page page_abc123 --type card --name "Revenue Card"

# Custom position and size (pixels)
pbi visual add --page page_abc123 --type scatter \
    --x 50 --y 400 --width 600 --height 350

# Named visual for easy reference
pbi visual add --page page_abc123 --type combo --name sales_combo

Each visual is created as a folder with a visual.json file inside the page's visuals/ directory. The template includes the correct schema URL and queryState roles for the chosen type.

Prerequisite: Measures Must Exist in the Semantic Model

visual bind writes field references into the visual JSON. It does not create measures — it only records that a measure should exist. If the measure is missing from the TMDL, every visual bound to it will show an error in Desktop.

Before binding any visual to a measure, verify the measure exists:

# Option A: create it via pbi-cli (requires pbi connect)
pbi connect
pbi measure create "Total Revenue" -e "SUM(Fact_Sales[Total_Revenue])" -t Fact_Sales

# Option B: check existing measures in the TMDL file directly
# Look for `measure '...' =` lines in SemanticModel/definition/tables/*.tmdl

After adding measures directly to a TMDL file (without pbi connect): close and reopen the .pbip file in Power BI Desktop. Desktop only reads TMDL on file open — it does not hot-reload TMDL changes made on disk.

Checklist before opening Desktop:

Every --field, --value, --indicator reference points to a real measure or column in the TMDL
Table names match exactly (case-sensitive in PBIR): "Fact_Sales" ≠ "fact_sales"
Measure names match exactly: "Total Revenue" ≠ "Total_Revenue"

Binding Data

Visuals start empty. Use visual bind with Table[Column] notation to connect them to your semantic model. The bind options vary by visual type -- see the type table below.

# Bar chart: category axis + value
pbi visual bind mybar --page p1 \
    --category "Geography[Region]" --value "Sales[Revenue]"

# Card: single field
pbi visual bind mycard --page p1 --field "Sales[Total Revenue]"

# Matrix: rows + values + optional column
pbi visual bind mymatrix --page p1 \
    --row "Product[Category]" --value "Sales[Amount]" --value "Sales[Quantity]"

# Scatter: X, Y, detail, optional size and legend
pbi visual bind myscatter --page p1 \
    --x "Sales[Quantity]" --y "Sales[Revenue]" --detail "Product[Name]"

# Combo chart: category + column series + line series
pbi visual bind mycombo --page p1 \
    --category "Calendar[Month]" --column "Sales[Revenue]" --line "Sales[Margin]"

# KPI: indicator + goal + trend axis
pbi visual bind mykpi --page p1 \
    --indicator "Sales[Revenue]" --goal "Sales[Target]" --trend "Calendar[Date]"

# Gauge: value + max/target
pbi visual bind mygauge --page p1 \
    --value "Sales[Revenue]" --max "Sales[Target]"

Binding uses ROLE_ALIASES to translate friendly names like --value into the PBIR role name (e.g. Y, Values, Data). Measure vs Column is inferred from the role: value/indicator/goal/max roles create Measure references, category/row/detail roles create Column references. Override with --measure flag if needed.

Inspecting and Updating

# List all visuals on a page
pbi visual list --page page_abc123

# Get full details of one visual
pbi visual get visual_def456 --page page_abc123

# Move, resize, or toggle visibility
pbi visual update vis1 --page p1 --width 600 --height 400
pbi visual update vis1 --page p1 --x 100 --y 200
pbi visual update vis1 --page p1 --hidden
pbi visual update vis1 --page p1 --visible

# Delete a visual
pbi visual delete visual_def456 --page page_abc123

Container Properties

Set border, background, or title on the visual container itself:

pbi visual set-container vis1 --page p1 --background "#F0F0F0"
pbi visual set-container vis1 --page p1 --border-color "#CCCCCC" --border-width 2
pbi visual set-container vis1 --page p1 --title "Sales by Region"

Visual Calculations

Add DAX calculations that run inside the visual scope:

pbi visual calc-add vis1 --page p1 --role Values \
    --name "RunningTotal" --expression "RUNNINGSUM([Revenue])"

pbi visual calc-list vis1 --page p1
pbi visual calc-delete vis1 --page p1 --name "RunningTotal"

Bulk Operations

Operate on many visuals at once by filtering with --type or --name-pattern:

# Find visuals matching criteria
pbi visual where --page overview --type barChart
pbi visual where --page overview --type kpi --y-min 300

# Bind the same field to ALL bar charts on a page
pbi visual bulk-bind --page overview --type barChart \
    --category "Date[Month]" --value "Sales[Revenue]"

# Resize all KPI cards
pbi visual bulk-update --page overview --type kpi --width 250 --height 120

# Hide all visuals matching a pattern
pbi visual bulk-update --page overview --name-pattern "Temp_*" --hidden

# Delete all placeholders
pbi visual bulk-delete --page overview --name-pattern "Placeholder_*"

Filter options for where, bulk-bind, bulk-update, bulk-delete:

--type -- PBIR visual type or alias (e.g. barChart, bar)
--name-pattern -- fnmatch glob on visual name (e.g. Chart_*)
--x-min, --x-max, --y-min, --y-max -- position bounds (pixels)

All bulk commands require at least --type or --name-pattern to prevent accidental mass operations.

Supported Visual Types (32)

Charts

Alias	PBIR Type	Bind Options
bar	barChart	--category, --value, --legend
line	lineChart	--category, --value, --legend
column	columnChart	--category, --value, --legend
area	areaChart	--category, --value, --legend
ribbon	ribbonChart	--category, --value, --legend
waterfall	waterfallChart	--category, --value, --breakdown
stacked_bar	stackedBarChart	--category, --value, --legend
clustered_bar	clusteredBarChart	--category, --value, --legend
clustered_column	clusteredColumnChart	--category, --value, --legend
scatter	scatterChart	--x, --y, --detail, --size, --legend
funnel	funnelChart	--category, --value
combo	lineStackedColumnComboChart	--category, --column, --line, --legend
donut / pie	donutChart	--category, --value, --legend
treemap	treemap	--category, --value

Cards and KPIs

Alias	PBIR Type	Bind Options
card	card	--field
card_visual	cardVisual	--field (modern card)
card_new	cardNew	--field
multi_row_card	multiRowCard	--field
kpi	kpi	--indicator, --goal, --trend
gauge	gauge	--value, --max / --target

Tables

Alias	PBIR Type	Bind Options
table	tableEx	--value
matrix	pivotTable	--row, --value, --column

Slicers

Alias	PBIR Type	Bind Options
slicer	slicer	--field
text_slicer	textSlicer	--field
list_slicer	listSlicer	--field
advanced_slicer	advancedSlicerVisual	--field (tile/image slicer)

Maps

Alias	PBIR Type	Bind Options
azure_map / map	azureMap	--category, --size

Decorative and Navigation

Alias	PBIR Type	Bind Options
action_button	actionButton	(no data binding)
image	image	(no data binding)
shape	shape	(no data binding)
textbox	textbox	(no data binding)
page_navigator	pageNavigator	(no data binding)

Suppressing Auto-Sync (--no-sync)

By default, every write command automatically syncs Power BI Desktop. When adding or binding many visuals in sequence, Desktop reloads after each one.

Use --no-sync on the visual command group to batch all changes, then call pbi report reload once at the end:

# Suppress sync while building visuals
pbi visual --no-sync add --page overview --type card --name rev_card
pbi visual --no-sync bind rev_card --page overview --field "Sales[Total Revenue]"
pbi visual --no-sync add --page overview --type bar --name sales_bar
pbi visual --no-sync bind sales_bar --page overview --category "Product[Category]" --value "Sales[Revenue]"

# Single reload when all visuals are done
pbi report reload

JSON Output

All commands support --json for agent consumption:

pbi --json visual list --page overview
pbi --json visual get vis1 --page overview
pbi --json visual where --page overview --type barChart

power-bi-visuals

同仓库更多 Skills

同仓库更多 Skills

Power BI Visuals Skill

Adding Visuals

Prerequisite: Measures Must Exist in the Semantic Model

Binding Data

Inspecting and Updating

Container Properties

Visual Calculations

Bulk Operations

Supported Visual Types (32)

Charts

Cards and KPIs

Tables

Slicers

Maps

Decorative and Navigation

Suppressing Auto-Sync (--no-sync)

JSON Output

Power BI Visuals Skill

Adding Visuals

Prerequisite: Measures Must Exist in the Semantic Model

Binding Data

Inspecting and Updating

Container Properties

Visual Calculations

Bulk Operations

Supported Visual Types (32)

Charts

Cards and KPIs

Tables

Slicers

Maps

Decorative and Navigation

Suppressing Auto-Sync (--no-sync)

JSON Output