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 ChampionRight, 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
Checked it out and calculation groups only accept Measures and not Columns. Thank you for your answers and replies.