Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Struggling with some basics here I feel so would appreciate help!
I have a report where I want respondents to be able to switch between 3 main ways of viewing the data:
Please could someone point me in the direction of:
TIA from a novice trying to learn!
Solved! Go to Solution.
I think if you wanted to go that route, bookmarks would be the better option.
Thanks for the quick response Clay - very informative. From what I can see this creates the same view three different way.s If I have multiple pages is there a way that I can apply these filters across all the pages i.e apply them from one selection rather than duplicating and applying page level filters.
Thank you!
I think if you wanted to go that route, bookmarks would be the better option.
You have a couple of options here. Both of which can produce the same result and have the same basic steps. Either way you go you'll have to filter the data to achieve the same result.
For View 1. you don't need any filters, you just need to build your report.
For View 2. drop field x into the filter panel for filters on this page and set it equal to 1
For View 3. filter the page by field y using the TopN feature. TopN would need to equal 1 so it can pick up only the highest value.
Now for the toggle. You can create bookmarks and buttons to toggle between each view. However, I personally don't like working with bookmarks. I always end up messing up the bookmarks when I update them. Nothing against bookmarks, I just try not to use them.
What I would do is create view #1 and duplicate the tab 2 more times. Apply the filters for views 1 and 2 to the other two pages, and use page nagivation between the three. You can hide the additional tabs if you want a cleaner look.
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |