Skip to main content
cancel
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

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
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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.