Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
Need some urgent help using bookmark with Slicer choice.
Basically I have 2 grids (Grid1 and Grid2) and 1 slicer (Slicer1)
If on Slicer1 "All" option is selected then I have to show Grid1 (and hide Grid2) and if any other are item is selected on the slicer1 then I have to show Grid2 (only and hide Grid1).
Earlier when I used bookmark I could make use ot images and thus link bookmarks however in above case running out of ideas. Please help
Solved! Go to Solution.
Agree with @parry2k, we can only use measure as a workaround, but column header will not be hidden.
Attached PBIX file is a simple sample. When we select 1 in the slicer, Table1 values will be shown. If we select 2 in the slicer, Table2 values will be shown.
Best Regards,
Herbert
Agree with @parry2k, we can only use measure as a workaround, but column header will not be hidden.
Attached PBIX file is a simple sample. When we select 1 in the slicer, Table1 values will be shown. If we select 2 in the slicer, Table2 values will be shown.
Best Regards,
Herbert
Could you please help me to achive this. I guess your answer is what i need into my data. Please see the screenshot: i want to see only on column data at the time. Is this possible in slicer like you have used in your soltuion. Any help is appriciated.
PS: I already tried bookmark but that having too many limitations.
Thank you, Kulchandra
Unfortunately you cannot select bookmark on slicer selection, currently it only works with image which you already mentioned in your post.
Only work around I can think of is to create measure which you use in grid and those measure return blank values based on slicer selection, it will show blank grid but will still have headers.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
76 | |
63 | |
55 |
User | Count |
---|---|
142 | |
107 | |
89 | |
84 | |
65 |