Forum Discussion
Visual Suggestion for multiple measures comparison
Hi All,
I need to show Measure X, Measure Y , Measure Z, Measure A, Measure B , Measure C (all 6 measures) in a visual for selected date and previous date of selected date. For selected week and Previous week, for selected month and Previous month. Would it be possible to pull all of them in a single visual. I tried showing selected date and previous date comparison using clustered column chart. I could not increase the width of the column and it does not look good.100% stacked column chart does not make sense.
Measure X-Measure A Comparison
MeasureY- Measure B Comparison
Measure Z - Measure C Coparison (Ex, Total streams, total matched, total single , total approved for selected date and previous date)
Do we have any tricks to show them in same visual or in different visual. Please suggest any custom visual where i can pull all measures for one comparison like date or week or month. Please refer any videos or documentation page. Thanks in advance
3 Replies
if the measures produce comparable data by orders of magnitude you can consider using radar charts.
Thanks for the response. I went with an alternative approach. i pulled the basic measure from all categories and used date hierarachy to drill down in bar chart for month to month comparison, week to week compariosn and days comparison.
Multi-Axis Spider/Radar Chart might be the useful chart in your case, available in ChartExpo for Excel add-in. Also available in Google Sheets, they have custom visuals in Power BI as well.
This is Multi-axis Spider Chart
There is another chart named, Circular Org Chart, might be it will be good for you.
Thanks & Regards,
