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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

% GT of a column of type percent gives unusual sum value when charted with a clustered bar graph

Hi all,


I have a table with data that looks like so;


| Item Name | Availability  | Grouping|
| item 1         | 0.9%            |Group1 |
| item 2         | 0.2 %           |Group2 |
| item 3         | 0.5%            |Group1 |
| item 1         | 1.0%            |Group2 |
| item 5         | 0.01%          |Group1 |
| item 2         | 0.02%          |Group2 |


I am charting this on a clustered bar graph categorised by item name and the value Availability, issue is the availability  sum shows abnormal figures like 25000% for each category. Please kindly help how this should give figures between 0-100%


Super User
Super User

@jefflanye , if Availability values are like 0.09 then use % property. if this is already 9, then do not use percent display


Values are like 0.01, 0.9 etc, could you please explain more, I have not got you well.

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors