Showing a Percent of a Percent In One Visual

[ajmonster]

Hello

I would like to use the bar chart to display an overall percentage, and then upon clicking through corresponding visuals the bar chart will show me a percentage of the overall incompletion percentage.

IE, suppose I'm measuring incomplete tasks among 3 groups. Maybe there are 15 tasks to be completed, with 5 tasks to each group. Suppose Group A has 2 tasks incomplete, Group B has 4 tasks incomplete, and Group C has 1 task incomplete. I would like my bar chart to initially show that overall we have 47% incomplete. Now, when I click on Group A in a separate visual I would like to see that out of the 47% overall incomplete tasks (this bar should be transparent now), Group A accounts for 29% of those incompleted tasks - and Group B accounts for 57% and Group C accounts for 14%.

[Ashish_Mathur]

Hi,

Paste the dataset in text form so that it can be copied to Excel/PowerBI desktop.