Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Allow any visual to show values as % of total (like Pie charts) without needing a DAX measure

Currently, only Pie and Donut charts can automatically show data labels as a percentage of total. For all other visuals (like Bar, Column, Line, or Treemap), users must manually create a DAX measure to calculate “% of total.”

This creates extra complexity for report authors and is inconsistent with the simplicity of Pie charts.


Add a visual-level option (in the Format or Data labels pane) to “Show value as → Percent of total”, similar to Excel’s “Show Values As” or Power BI’s existing “Show Value As” feature for Table / Matrix visuals.

The visual should handle the denominator automatically based on current filters and slicers, no custom measure required.

Status: New
Comments
Seaglass
New Member
This should work for bar, column, line, treemap, etc. visuals, just like the automatic % display in Pie charts.
mrshoes
New Member
Agreed, this kind of feature woulf be incredibly useful and consistent, as well as opening up the options for users not as comfortable with creating measures. It also means there's some consistency with how these percentages are calculated.