Forum Discussion
Solved
Dynamically Limited Matrix Based off Parameter Slicer
Hello, I am recreating a report in Power BI that currently is built in Tableau. In the Tableau version they have a parameter slicer that filters the report for weekly, monthly, and quarterly res...
I was able to get it to work using a calculated column with the SWITCH function to label the weeks I needed with a 1 and the rest of the weeks with a 0. I then filtered the visual to that new column = 1 and it worked.
There are probably other ways to do it more efficiently using the existing field parameters and measures, though.
Appeciate your willingness to help!
I was able to get it to work using a calculated column with the SWITCH function to label the weeks I needed with a 1 and the rest of the weeks with a 0. I then filtered the visual to that new column = 1 and it worked.
There are probably other ways to do it more efficiently using the existing field parameters and measures, though.
Appeciate your willingness to help!