Forum Discussion
Switch Column Headers in Matrix Visual
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 , 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/
2 Replies
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/amitchandak thanks for this. Yup these helped me to choose the better option.