Forum Discussion

LinhNguyen's avatar
LinhNguyen
Helper II
6 years ago

Clustered column chart clustered by value

Is there a clustered column chart that can show clusters based on values?

 

I'm looking for a chart that can show multiple values at once and cluster columns by values. In the examples below, 0-30days; 30-60 days, 60-90 days... are different value fields. FY20 Wk1, FY 20 Wk 15... are time stamp (categorical field).

I could create the first chart but haven't found a way to create the second. 

The chart above, for example, is clustered by timestamp (Categorical Axis)

I need to create the chart below. Does anyone know how to do this?

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    6 years ago

    Hello LinhNguyen,

     

    Did you try interchanging fields between 'Axis' and 'Legend', i.e Days value fields as Axis and Timestamp as Legend?

    Please let me know the result if you tried.

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago
     
    As rajulshah said before, you may try this. If you want the same chart,you should create a new caculated columns that divide the value by millions and update the title.
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.