Bookmarks and Button for multiple columns

[Saxon10]

I have the following columns are Id, Code, Result1, Result2, Result1 colour code and Result2 colour code in data table.

How can I add two columns(Result1 and Result2) in same button and I would like to get the bookmarks depends on the button selection. (Result1 or Result2)

Data:

https://www.dropbox.com/s/73fbph0qmux8opp/Book%20marks%20and%20button.pbix?dl=0

[Anonymous]

Hi  @Saxon10 ,

Sorry, after research, we can’t implement this idea in the same page, we can only use bookmarks in two pages.

I would suggest you add it as an idea on Power BI Ideas to improve Power BI on this feature. 

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.

[Anonymous · Accepted solution]

Hi  @Saxon10 ,

After research, the slicer seems to be unable to achieve such a result, you can consider using the bookmark button to achieve the conversion of two pages

Here are the steps you can follow：

1. Create a new page Page2 and place the result of Result2 in Page2.

2. In Bookmark, add bookmarks based on COUNT&STATUS and Page2 respectively

3. In COUNT&STATUS, click Insert – Buttons – Bookmark.

4. Click Action – Bookmark – Bookmark – Page2.

5. In Page2, click Insert – Buttons – Bookmark.

6. Click Action – Bookmark – Bookmark – Count&Status.

7. Result.

Click the Result button above to go to the corresponding Book page.

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

[Saxon10]

@Anonymous,

I need one more help please. I want the same result within the same page instead of two pages. 

How can I make bookmark, button and filter within the same page.

If I select the result 1 button then it will reflect only Result 1 status with colour code and result 1 count status meantime the result 2 button, status with colour code and count status need to be turned off) 

[MFelix]

Hi @Saxon10 ,

Contrary to what @Anonymous  says this is possible in a single page however you need to make the use of two buttons and hide them.

You can implement has many bookmarks has you need in the same page even within the same visual not necessaraly within different pages.

Check the file attach with the setup.

[Saxon10]

Thank you so much for your help and reply.

your solution working well. 

[MFelix]

Hi @Saxon10 ,

How are you making the colour coding selection?

In case of the count is easy to return the correct calculation using a single measure:

Count measure = SWITCH(SELECTEDVALUE(Slicer[Result]), "Result 1", COUNT(REPORT[Result1]), "Result 2", COUNT(REPORT[Result2]))

However I'm getting issue on understanding the logic of the colour, since you have several colour values for each Code how do you set wich colour to return?

[Saxon10]

@MFelix,

Thanks for your reply and sorry for the late response. 

I don't want colour code for counting. I want colour code for only the status.