Visual Suggestion for multiple measures comparison

[01UmaManoharan]

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

[MQaiserJaved]

Hi @01UmaManoharan 

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,

[01UmaManoharan]

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.

[lbendlin]

if the measures produce comparable data by orders of magnitude you can consider using radar charts.