cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Saxon10
Post Prodigy
Post Prodigy

Bookmarks and Button for multiple columns

 

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:

Saxon10_0-1638711726621.png

 

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

 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

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.

vyangliumsft_0-1638945722073.png

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

vyangliumsft_1-1638945722074.png

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

vyangliumsft_2-1638945722076.png

4. Click Action – Bookmark – Bookmark – Page2.

vyangliumsft_3-1638945722078.png

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

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

vyangliumsft_4-1638945722078.png

7. Result.

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

vyangliumsft_5-1638945722079.png

 

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

View solution in original post

7 REPLIES 7
v-yangliu-msft
Community Support
Community Support

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. vyangliumsft_0-1640159612499.png

 

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.

v-yangliu-msft
Community Support
Community Support

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.

vyangliumsft_0-1638945722073.png

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

vyangliumsft_1-1638945722074.png

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

vyangliumsft_2-1638945722076.png

4. Click Action – Bookmark – Bookmark – Page2.

vyangliumsft_3-1638945722078.png

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

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

vyangliumsft_4-1638945722078.png

7. Result.

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

vyangliumsft_5-1638945722079.png

 

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

@v-yangliu-msft,

 

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) 

 

 

Saxon10_0-1639258028727.png

 

Hi @Saxon10 ,

 

Contrary to what @v-yangliu-msft  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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thank you so much for your help and reply.

your solution working well. 

MFelix
Super User
Super User

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?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



@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.

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors