Forum Discussion
Buttons and changed screen
Hi,
Can anyone help me to understand how can I implement the following idea?
I want to put buttons in my Power BI report. I want that each click on one of the buttons, will present table with related information (like the slicer).
In addition, I need a button that if I click on it - it won't show the table (like "clean screen" button).
I have tried to do it with Bookmars, with no success.
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Flag = IF( HASONEVALUE('Table'[Group1]),0,1)2. Use Bookmarks.
Create Benchmarks for Electricity products:
Create a Bookmarks for Food products:
Create a Bookmarks for Wearing Products:
Create Reset's Bookmarks:
Place [Flag]in Filters, set is=1, apply filter.
3. Insert – Buttons – Navigator – Bookmark navigator.
4. Result:
Select which Button to display.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Flag = IF( HASONEVALUE('Table'[Group1]),0,1)2. Use Bookmarks.
Create Benchmarks for Electricity products:
Create a Bookmarks for Food products:
Create a Bookmarks for Wearing Products:
Create Reset's Bookmarks:
Place [Flag]in Filters, set is=1, apply filter.
3. Insert – Buttons – Navigator – Bookmark navigator.
4. Result:
Select which Button to display.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous , Have you an anonymised sample of your report that you could share?
Hi,
I don't have an anonymised sample, but let me explain by example:
I need buttons that their names are:
Electricity products
Food products
Wearing products
Reset
Then, I want that each time that I will click on each one of the buttons, I will see the list of its "childrens" meaning:
* When I'll click on "Electricity products" - I will see table with the lines: fridge, microwave, oven, air conditioner.
* When I'll click on "Food products" - I will see table with the lines: bread, cheese, pasta, toast, rice.
* When I'll click on "Wearing products" - I will see table with the lines: shirt, pants, jacket, hat.
* When I'll click on "Reset" - the table will "disappear".
Pay attention that all the information comes from a table of course, meaning, I can use the slicer that looks like a button and the first 3 will work for me. My only problem is the "Reset" button, since I need to "disappear" the table to "clean" the screen. As I said, I try to do it with bookmark, but it doesn't work.
Any idea?
