Skip to main content
Glama

set_data_bars

Apply data bars to a measure in Power BI visuals, turning values into in-cell bars with customizable colors, direction, and axis. Set min/max for controlled scaling.

Instructions

Add DATA BARS to a measure column in a table/matrix: an in-cell bar whose length tracks the measure, with a positive colour and an optional negative colour. reverseDirection draws bars right-to-left; hideText shows the bar only (no value text); axisColor sets the zero-axis colour; minValue/maxValue pin the bar scale (omit for auto - the default fixes the old min==max bug where bars never rendered). Verify the render in Desktop.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
pageYespage name or displayName
visualYestable/matrix visual name
measureYesmeasure that drives the bars
hideTextNoshow the bar only, hide the value text
maxValueNoexplicit maximum bar value (omit for auto)
minValueNoexplicit minimum bar value (omit for auto)
axisColorNozero-axis colour hex (default #000000)
measureTableYestable that owns the measure
negativeColorNooptional negative bar colour hex e.g. #E81123
positiveColorYespositive bar colour hex e.g. #1B8A4B
reportSessionIdYes
reverseDirectionNodraw bars right-to-left
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It discloses parameter behaviors (reverseDirection, hideText, axisColor, minValue/maxValue) and even notes a bug fix for the min==max case. It does not cover side effects or reversibility, but provides substantial behavioral detail.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is concisely structured: first sentence gives the primary purpose, second sentence lists parameter behaviors, and a final practical tip to verify in Desktop. Every sentence is informative with no filler.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The description covers the main behavior and parameter effects, and the tip to verify in Desktop adds practical context. However, it does not explain prerequisites like needing an open session or how to locate the visual, though these are partially covered by the schema parameter descriptions.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is high (92%), so baseline is 3. The description adds extra meaning by explaining how each parameter affects the visual (e.g., bars right-to-left, bar-only display, zero-axis colour) and the min/max bug fix, which is beyond the schema's default/type info.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states it adds data bars to a measure column in a table/matrix, with a specific verb and resource. However, it does not explicitly distinguish this from sibling tools like add_svg_databar, so it lacks sibling differentiation.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies usage context (for table/matrix visuals with measure columns) but provides no explicit alternatives or exclusions. There is no guidance on when to prefer this tool over similar bar-formatting tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/cyphonica/powerbi-pbix-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server