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
Community ChampionCreate 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
Already had this idea. As mentioned in the question, I have about 70+ columns so creating 70+ bookmarks and hiding one visual from another will be a huge task. The exact solution I'm looking for is mentioned by SolomonovAnton . The only hurdle is the report server version is lower than the version mentioned by him.
- PaulDBrown
Final try before I give up! Might be worth exploring the options Calculation Groups has to offer: point 10 in this blog might help
https://apexinsights.net/blog/10-uses-for-calculation-groups