Forum Discussion

jdwalker5's avatar
jdwalker5
Helper II
2 years ago
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...
Need Help
  • jdwalker5's avatar
    jdwalker5
    2 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jdwalker5 ,

Based on the information you have provided, can you provide some sample data (without privacy information) and your desired output, so that we can better understand and solve the problem you are experiencing.

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.