Graph BaseLine

[Anonymous]

Risk	baseline	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22
<20	7%	6%	5%	4%	4%	5%
30-50	34%	45%	45%	46%	44%	46%
50+	59%	49%	50%	50%	51%	49%
Total	100%	100%	100%	100%	100%	100%

Hi,

I need to develop this graph in my dashboard. I need guidance on how to create this graph of Baseline. All % are showing measure values instead of column values.

Regards,

[Anonymous]

Any further help on my above request. 

[amitchandak]

@Anonymous, Unpivot other columns then Risk

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Power Query Table.Unpivot, Table.UnpivotOtherColumns: https://youtu.be/0FEGEAz9UMw

[Anonymous]

Risk	baseline	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22
<20	7%	6%	5%	4%	4%	5%
30-50	34%	45%	45%	46%	44%	46%
50+	59%	49%	50%	50%	51%	49%
Total	100%	100%	100%	100%	100%	100%

All % are showing measure values instead of column values. so it is not possible to unpivot data.