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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
DebbieE
Community Champion
Community Champion

Waffle Chart showing incorrect Percentages

I wanted to change a Pie chart into a waffle chart but the percentages are different.

 

In my pie chart I have Values: Hours,  Category: Data Number of Employees Group

 

Less than 10 Employees 59.43%

No Employees                 22.1%

10 to 50 Employees        14.38% 

NULL                               2.16%

50 to 100 employees      1.74%

 

But the Waffle chart shows

 

Less than 10 Employees  100%

No Employees                 37%

10 to 50 Employees        24% 

NULL                               4%

50 to 100 employees       3%

Over 100 Employees       0%

 

Why is the percentages different between the pie and waffle chart? I know my less that 10 employees make nearly 60% of the data, not 100. Can anyone help me understand whats going on here?

6 REPLIES 6
GlassShark1
Helper III
Helper III

You need to enter a measure in the Max Values field to restrict the visual. 

So Category Data = your attribute, Values = sum of your values and Max Values = something like the below:

Max Sum =
CALCULATE(SUM('Fact_Tbl'[Value]),
ALL('Fact_Tbl')
)

Should work then. Please mark as solution if it does 🙂
v-shex-msft
Community Support
Community Support

Hi @DebbieE ,

 

It sounds like you're work with a third party custom visual, I'd like to suggest you contact to visual author to get more information about the difference.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Any chance that Power BI could have an official Waffle chart because they look so much nicer than the pie chart?

Hi @DebbieE ,

 

If you click on support, you can find the github link to report issue:

https://github.com/kiewic/PowerBI-WaffleChart/issues


Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Ive added this to GitHub

 

Surely I must be missing the point of the chart though. It cant be displying percentages incorrectly. That would make it unuseable

DebbieE
Community Champion
Community Champion

I think I have been missing the point. The waffle chart appears to just be showing the number but its adding a % which is incorrect but I feel better in understanding whats actually happening

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.