Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.