Forum Discussion
How to plot multiple ratios on the same chart
SamerB,
Please check the measures in the PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1Nokz-iFj6hTkQDHxGz
Regards,
Lydia
- SamerB8 years agoFrequent Visitor
Thanks Anonymous for your time to recreate the example and the quick response.
What you send me is useful in terms of being able to plot True/False measures, instead of having to convert my values to 0/1 numbers as I was doing to be able to sum.
It still does not show ratios however (i.e. 2 houses out of 5), and plotting another bar for the total number of houses information isn't suitable.
I see it a very bothersome limitation for when the data doesn't have an axis or categories such as in my example.
Best,
Samer.
- Anonymous8 years agoNot applicable
SamerB,
I would recommend you unpivot columns in your table, then create a Matrix visual.
Or you can create a column chart as shown in the video below.
https://1drv.ms/v/s!AhsotbnGu1Nok0bIYnrjrgI3vSS6
Regards,
Lydia