Forum Discussion

nunnc01's avatar
nunnc01
Helper II
8 years ago

See Records from Card Visual

Hi all,

 

Still fairly new to Power BI...

 

I have a report that will contain lots of summary numbers and not graphs/charts etc as they take up too much room so using the Card visual is great as it takes up very little room however I need to be able to then see the records that the number shown in the card relates to. However, I understand that the Card visual does not allow you to See Records which is extremely frustrating.

 

Can anyone offer any suggestions on how I can replicate the See Records functionality for a card visual? or any design ideas on how I can fit a lot of summary numbers into one report with the ability to drill down to see the records.

 

Thanks

 

Chris

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Perhaps create a button and tie it to a bookmark that takes the user to a separate page with a table of the records?

    • nunnc01's avatar
      nunnc01
      Helper II
      8 years ago

      Thanks for the suggestions. I had looked at buttons but could not see anyway of getting the button to show the value of a datafield, only hardcoded text. Have I missed something?

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        8 years ago

        In the settings, you can tie to button to a bookmark. So, create a page and put the records for the card visual on that page. Create bookmark. Create button, tie button to bookmark so that when you click the button it goes to the bookmarked page. It's in the Action section of the settings for the bookmark.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi nunnc01

    As we all know that "See Data and See Records" support only the some visualization types, not inculding Card visual.

    A workaround as Greg_Deckler's suggestion is to create a shape and click the shape to go to see the data display on other page.

    First, you need to create a bookmark for the page displaying the data, see reference about using bookmark.

    Next, create a shape like a arrow(Home->Shape), then on "FORMAT SHAPE" pane, turn "Action" on and select "Type" as "bookmark".

    finally, when CTRL+click on the arrow shape, you will go to the bookmark page.

     

    Best Regards

    Maggie

     

    • nunnc01's avatar
      nunnc01
      Helper II
      8 years ago

      That's helpful thanks. Is there a way of passing filters and criteria through to the dataset so that it shows certain records instead of all of them?

       

      For example, on my frontsheet I have a slicer where the user can select their team and then the numbers in the card visuals that I have displayed are various counts of certain conditions from the dataset i.e. count of product where it equals "Red". What I would like is the ability for the user to be able to see the records behind those specific dynamic numbers, so if they see that for Team A the Red product shows as 5 they can click on that card, or a button near that to get to just those 5 records.

       

      Thanks again for your help so far

       

      Chris