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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Nihed
Helper III
Helper III

Help

 

Hello everyone,

I have a request and I can’t make it I should add % tooltips to the column charts.

Could you please help on this?

the chart:

 

Nihed_0-1645562620743.png

and I use these axes in this visual :

 

Nihed_1-1645562835564.png

 

 

 

 

 

1 ACCEPTED SOLUTION
MarkLaf
Super User
Super User

You can accomplish this with the line and clustered bar chart visual.

  1. Change to chart line and clustered bar chart
    MarkLaf_0-1645570911067.png
  2. Add the percent to the line field. You can simply re-add Headcount and change to show as % of total
    MarkLaf_1-1645571064655.png
  3. Then, assuming you don't actually want the line showing, change the stroke width to 0 in the format options
    MarkLaf_2-1645571198062.png

Result:

MarkLaf_7-1645572084867.png

Edit: Additional display setting considerations. For more consistent positioning, you can change Secondary y-axis > Range > Minimum to 0 and set Data label > Options > Position (column) to Inside end. And for cleaner style, it also makes sense to hide the secondary axis (turn off title and overall axis after setting minimum) and legend.

MarkLaf_8-1645572240113.png

View solution in original post

3 REPLIES 3
MarkLaf
Super User
Super User

You can accomplish this with the line and clustered bar chart visual.

  1. Change to chart line and clustered bar chart
    MarkLaf_0-1645570911067.png
  2. Add the percent to the line field. You can simply re-add Headcount and change to show as % of total
    MarkLaf_1-1645571064655.png
  3. Then, assuming you don't actually want the line showing, change the stroke width to 0 in the format options
    MarkLaf_2-1645571198062.png

Result:

MarkLaf_7-1645572084867.png

Edit: Additional display setting considerations. For more consistent positioning, you can change Secondary y-axis > Range > Minimum to 0 and set Data label > Options > Position (column) to Inside end. And for cleaner style, it also makes sense to hide the secondary axis (turn off title and overall axis after setting minimum) and legend.

MarkLaf_8-1645572240113.png

MarkLaf
Super User
Super User

All you need to do is add whatever measure or column with %s to the Tooltips field. Or by "tooltips" do you actually mean "data labels" (e.g. the numbers inside your bars rather than what is displayed in flyout when you hover on a bar)?

Thank you for returning,

what I want is to display the value in the bars in decimal and in percentage.

In this case is what I have to calculate a function (total percentage)?

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.