Forum Discussion
DebbieE
Community Champion
Community ChampionWaffle 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...
GlassShark1
Helper III
Helper IIIYou 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 =
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 🙂
Should work then. Please mark as solution if it does 🙂