Forum Discussion

Saxon10's avatar
Saxon10
Post Prodigy
4 years ago
Solved

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 woul...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

MFelix's avatar
MFelix
Super User
4 years ago

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's avatar
    Saxon10
    Post Prodigy
    4 years ago

    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.