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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jefflanye
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%

 

2 REPLIES 2
amitchandak
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

Hello,

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

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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