Forum Discussion

OPS-MLTSD's avatar
OPS-MLTSD
Post Patron
4 years ago
Solved

Turn Card Visual with values into buttons

Hello,

 

I have a report that looks like this: 

I have two card visuals that show two different types of groups Bilingual (Yes or No) and Newcomer (Yes or No). In the cards above, I am counting clients who identify as Bilingual and in the bottom card I am counting clients who identify as Newcomer. I would like to be able to click on the card and have it function as a button so that if someone were to click on the Newcomer card for example, the visuals on the report would filter to show data for only that particular group. If someone could please help me figure this out, that would be great! Thank you!

7 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    Hi, OPS-MLTSD ;

    You can insert two blank buttons and set the border and color to transparent,
    Next, create two bookmarks and turn on the active button.
    1.create blank button.

    2.create two different bookmarks.

    3.set blank button.

    4.group blank button and card .

    The final output is shown below: (ctrl+click)

     

    https://www.youtube.com/watch?v=NVGjthYx_4Q

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • OPS-MLTSD's avatar
      OPS-MLTSD
      Post Patron

      thanks for the example! Just wondering do I place any hidden slicer? for example to choose the views of "A" you first had to filter the page to show results of "A" only. I have multiple columns that have Yes and No options - Bilingual is a column with Yes and no options, and so is Newcomer with Yes and No options. Does this mean that I have to create two hidden slicers? 

      • v-yalanwu-msft's avatar
        v-yalanwu-msft
        Community Support

        Hi, OPS-MLTSD ;

        Because the card is not currently unable to achieve the filtering function, or you can mention an idea. So I think maybe we really need to set up two different filters.

        Best Regards,
        Community Support Team_ Yalan Wu
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Even this worked fine to me. But I was unable to format edit interactions on this. 

    Let me explain my situation here. 

    I had 5 seperate cards and I had two bar charts below the cards. 

    When I use the procedure as outlined, when I click on a card, it is filtering out bar charts and at same time it is filtering on the cards. I dont want when i click on on card, other cards should not filter. I tried using edit interactions but it is not working out. 

     

    Any help would be greatly appreaciated 

     

    Regards, 

    Rajesh Kumar Yarlagadda