Showing results for 
Search instead for 
Did you mean: 
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

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors