Forum Discussion

jgaard's avatar
jgaard
Frequent Visitor
1 year ago
Solved

Report with multiple views controlled by a slicer.

I have a Report, that I made for my boss. Now there is a need to expand the report and make it available to more people. At the moment I have 5 table views. I have a button that can change between v...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi jgaard,

     

    Thank you for reaching out to Microsoft Fabric Community Forum.

    Idrissshatila , Thanks for your quick response.

     

    I have created a sample Power BI file and attached it here. The report includes a sample slicer with multiple views based on the sample data. When a user selects a specific view from the slicer and clicks the arrow icon next to it, the report will navigate to the corresponding page. I hope  this method isuits your requirement else use the field parameters as super user suggested.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

     

    Regards,

    B Manikanteswara Reddy

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi jgaard ,

Just wanted to check if my answer helped solve your issue. If it worked, marking it as accepted helps others too. If you're still stuck, feel free to share more info and I can try to assist further.

Regards,

B Manikanteswara Reddy

jgaard's avatar
jgaard
Frequent Visitor
1 year ago

Yes that is the solution that I also suggest: Dynamic Page Navigation in Power BI Desktop | by @imVivRan | Analytics Vidhya | Medium

It works but if I am to make it so that I all combinations of my views, I'll be making 63 pages. 
And with a future 7th view it will be in the 120-ties and be very complex to maintain. 

I'll probably by asking around get it down to 10-20 pages (because some views will be irelevant) but that is still a lot of pages.