Hi Community
while trying to create a donut chart for some KPIs, i have some kpis that does not have a goal.
the problem is that if it does not have a goal, the visualisation looks weird.
See attached workbook
While attempting to track turn outs, there is a zone that does not have a capacity. But we are tracking attendance take up rates.
so when the filter is selected on zone 3 (venues F and G), the donut chart looks weird, as if 50% is exceeded.
The ideal (or expected) visual is that if there are no kpi indicated in the example case, the capacity of a venue is indicated as 0, i can represent it as a full circle.
i tried many methods to work around but I am heading no where.
appreciate anyone who knows how to handle this situation.
Hi Gavin Wong,
I am understand if no capacity then no outline show but if you want to show 100% outline for Zone 3 then you need to change '% of total' calculation change which is as below:
IF [Capacity]>0 THEN
[Attendance]/[Capacity]
ELSE
1
END
Remove 'Attendance Cal' calculated measure and Drag and Drop your actual measure 'Attendance'
OR
Remove 'Exceed Cal' calculated measure and Drag and Drop your actual measure 'Exceed Cal'
OR
You will get full color in donut with above condition.
Please find attached workbook.
