Clustered column chart clustered by value

[LinhNguyen]

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?

[V-lianl-msft]

Hi @LinhNguyen ,

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.

[rajulshah]

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.

[LinhNguyen]

@rajulshah 

Yes, I did try it, and the chart was just a blank space.

[rajulshah]

@LinhNguyen, can you show the picture of the graph after interchanging the fields?