Add Count Variable Breakdown as Legend in Bar Char...

Anonymous · ‎06-27-2022

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

Anonymous · ‎07-01-2022

Anyone can help?

Anonymous · ‎06-27-2022

Data looks something like this. The count is if the metric is >-.2
Metric Count
    0.2300 1
   (0.7000) 0
   (0.2400) 0
   (0.3500) 0
    0.1200 1
    0.8500 1

Seanan · ‎06-27-2022

Hi @Anonymous

I believe I know what you require now.

Would you be able to provide the PBIX file without any sensitive data?

Anonymous · ‎06-29-2022

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