set_chart_axis
Category / value axis title, scale, format
How to use it
Project documentation lists set_chart_axis for the Pbirb MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.
Install Pbirb MCP
uvx pbirb-mcpOther tools in Pbirb MCP (39)
Append an Image to the body
Append a Textbox to <Body>/<ReportItems>
A <Line> report item
A list region (single-column tablix template)
Append <QueryParameter> (e.g. =Parameters!DateFrom.Value)
A <Rectangle> container (group other items, control page breaks)
Append a <Filter>. Operators: Equal, NotEqual, GreaterThan, In, Between, Like, TopN, ...
Promote a table to a matrix (row + column groups) — see docs/MATRIX-cookbook.md
Top-level inventory: data sources, datasets, parameters, tablixes, page setup
Cheat-sheet of common RDL expression patterns (countwhere, sumwhere, iifformat helpers build these)
Report parameters with data type, prompt, and flags (multi-value, hidden, nullable, allow-blank)
Tablix layout: columns, row/column groups, sort expressions, filters, visibility
A basic Column chart: single category axis grouped by categoryfield, single Y series =Sum(Fields!<valuefield>.Value). Change <Type> post-insert (Bar / Line / Pie / etc.).
A basic Tablix mirroring the fixture's shape — header row with the column name as a static label, detail row binding to =Fields!<column>.Value. One column per requested field.
Re-derive the <Fields> list from the query's column metadata
Remove a named Textbox / Image / Tablix from the body
Drop a query parameter (and clean up empty <QueryParameters>)
Remove by ordinal index from listtablixfilters
Zebra-stripe a tablix's detail row with BackgroundColor=IIf(RowNumber(Nothing) Mod 2, "<a>", "<b>")
The <Body> region's overall height
Set RowSpan / ColSpan on a cell
Toggle and format data labels
Legend visibility and placement
Category/series grouping expression
Column / Bar / Line / Area / Pie / ... per series
Chart title text/expression
Drive detail-row BackgroundColor from an expression
Repoint a <DataSource> at a Power BI XMLA endpoint. DataProvider=SQL (the AS provider id).
Set <Visibility> on the Details group
Set <Visibility> on any named ReportItem (Tablix, Textbox, Image, Rectangle, Subreport, Chart). Group / detail-row visibility have their own tools.
Swap PageHeight/PageWidth to match Portrait or Landscape. Idempotent.
Page dimensions, margins, columns. All fields optional.
Set the matrix corner cell text/expression
Set the tablix's overall <Width> / <Height>
Routes properties to the right nested <Style> node automatically: box-level (BackgroundColor, Border, VerticalAlign), paragraph-level (TextAlign), run-level (FontFamily, FontSize, FontWeight, Color, Format)
Apply one style to many textboxes in a single call
Style every cell of a tablix row at once (header / detail / footer)
Replace <DataSet>/<Query>/<CommandText> with a DAX expression
Change the value expression of an existing query parameter