Switch Column Headers in Matrix Visual

[Anonymous]

Hi Team,

I have the below 3 Columns in my data.   

Orderid	AgeSlab	UpdatedAge slab
1	20+ Days	0-1Days
2	20+ Days	2-5Days
3	11-19Days	0-1Days
4	11-19Days	2-5Days
5	8-10Days	0-1Days
6	8-10Days	2-5Days
7	6-7Days	0-1Days
8	6-7Days	2-5Days
9	2-5Days	0-1Days
10	2-5Days	2-5Days
11	0-1Days	0-1Days

I need to give a user a flexibility to choose between AgeSlab and UpdatedAgeSlab in a matrix visual.

The slabs go in the colum header and the values will be Count(orderid).

I tried the below dax for creating a calculated column with a supporting table created.

if(selectedvalue(supporttable[column1])="Created",table1[AgeSlab],table1[UpdatedAgeSlab])

but this is not working.

Any help on this please.

[Anonymous]

@amitchandak  thanks for this. Yup these helped me to choose the better option.

[amitchandak · Accepted solution]

@Anonymous , If want change axis, row/column or legend. You have three options

bookmarks, unpivot and one option in direct query

Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/

https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/