Forum Discussion
Solved
How to dynamically change columns in a Matrix or Chart
I have three components as mentioned above. Base data with two independent columns and one dependent column. A matrix to show the sum and count calculations. A slicer containing the colu...
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
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.