Buttons and changed screen

[Anonymous]

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.

[Anonymous · Accepted solution]

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

[davehus]

Hi @Anonymous , Have you an anonymised sample of your report that you could share?

[Anonymous]

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?