Forum Discussion
Add Count Variable Breakdown as Legend in Bar Chart
I have a Bar Chart using a metric. What I want to do is have a breakdown in the legend showing the count of variable =1 and count of variable = 0
I was able to get what I want, via tooltip, but I wanted it all inside of the same Viz. So the size of the bar should be the same, but with that color breakdown inside of it based on the count of variable = 1 and variable = 0
6 Replies
Hi Anonymous
Is this what you are looking for?
If so would you be able to send a picture of your table where we need to count the 1's and 0's, so that I can help replicate this result for you.
Hi Anonymous
I believe I know what you require now.
Would you be able to provide the PBIX file without any sensitive data?
Person;Metric
Person A;4.09
Person A;1.14
Person B;1
Person A;0.74
Person B;0.71
Person B;0.36
Person C;0.33
Person B;0.33
Person D;0.32
Person A;0.32
Person D;0.3
Person A;0.26
Person E;0.23
Person A;0.2
Person F;0.17
Person G;0.17
Person H;0.15
Person B;0.15
Person E;0.12
Person D;0.09
Person B;0.09
Person B;0.09
Person B;0.07
Person B;0.06
Person D;0.05
Person A;0.04
Person G;0.03
Person B;0.01
Person B;0.01
Person D;0
Person B;0
Person D;0
Person A;0
Person B;0
Person H;0
Person G;-0.01
Person B;-0.01
Person F;-0.03
Person F;-0.03
Person B;-0.03
Person F;-0.04
Person B;-0.05
Person D;-0.06
Person D;-0.06
Person D;-0.08
Person C;-0.08
Person B;-0.09
Person G;-0.1
Person D;-0.1
Person B;-0.1
Person H;-0.11
Person A;-0.13
Person B;-0.13
Person A;-0.14
Person A;-0.15
Person B;-0.16
Person B;-0.17
Person B;-0.17
Person A;-0.17
Person G;-0.2
Person D;-0.31
Person B;-0.32
Person H;-0.36
Person G;-0.43
Person D;-0.53
Person A;-0.58
Person B;-0.67
Person B;-0.68
Person A;-0.68
Person D;-0.69
Person A;-0.75
Person E;-0.75
Person D;-0.76
Person E;-0.99
Person B;-1
Person B;-1.42
Person F;-2.06
Person B;-2.4
Person G;-9.54
Person G;-13.86
