Forum Discussion
How to dynamically change columns in a Matrix or Chart
I think new feture field parameters from Power BI May update 2022 will help you
https://www.youtube.com/watch?v=LTdpe2ENW4M&t=177s
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Super UserI think new feture field parameters from Power BI May update 2022 will help you
https://www.youtube.com/watch?v=LTdpe2ENW4M&t=177s
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
This is a great solution for the May 2022 version, SolomonovAnton.
I'm using May 2021 because the Report server is compatible with it. So if there's a solution to May 2021 Please share, I'll accept this as the solution too.
PaulDBrownCommunity Champion
Create a new unrelated table (use the Enter Data option in the ribbon an type in the names of the measures you wish to toggle between). Use this table as the slicer.
next create the following equivalent measure to use in the matrix:
toggle = IF(SELECTEDVALUE(SlicerTable[Measure]) = "Measure 1", [Measure 1], [Measure 2])
This will not solve my objective. I'm actually trying to make the dynamic change of columns and not measures.
- PaulDBrown
Right, sorry, I see what you mean. In that case, you can use buttons and bookmarks to toggle between visuals