How to Display the Percentage of Boolean Values for Multiple Fields in One Visualization

[daryllabar]

I have a around 20 columns in my table, that are true/false values.  I want to display the true percentages for each column in a single visulization. Is this possible, if so how?

For example:

AsOfDate	Option A	Option B	Option C	Option D	Option E	Option F	Option G
1/1/2020	1	0	1	1	1	1	1
1/2/2020	1	0	1	1	1	1	1
1/3/2020	1	0	1	1	1	1	1
1/4/2020	1	0	1	1	1	1	1
1/5/2020	1	0	1	1	1	1	1
1/6/2020	1	0	0	1	1	1	1
1/7/2020	1	0	0	1	1	1	0
1/8/2020	1	0	0	1	1	0	0
1/9/2020	1	0	0	1	0	0	0
1/10/2020	1	0	0	0	0	0	0

Option A: 100%

Option B: 0%

Option C: 50%

Option D; 90%

Option E: 80%

Option F: 70%

Option G: 60%

[amitchandak · Accepted solution]

@daryllabar , first unpivot

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

After that with new option column

try this divide(sum(Table[Option]),count(Table[Option]))

[daryllabar]

After I unpivoted, I just select a bar chart and added the values column to it, sand selected Average for the column and that did what I want.  Although I wish the label would be 95% rather than .95, but it works!

[daryllabar]

After the Unpivot, I have 500k rows.  I'm guessing that should not be transposed, since that will creat 500k columns, or am I misunderstanding it?