Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
4 years ago
Solved

Drillthrough Card

Hi,

 

Is it possible to have a drill through in Power BI where it goes into the drillthrough page and passes the name of the field into a card as a title?

 

E.G. if I have a generic item drillthrough landing page but I'm drilling through to it from two different graphs that that are drilling from the order number and also the day of the week sales. I would want the card to say in this case if its the order number or the day of the week orders? It would just save having so many drillthrough landing pages when they're unecesarry.

 

Thanks in advance

 

Liam

Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    HEy lherbert501 ,

     

    yes, you can only have one value per card. But on a drillthrough page you can have multiple visuals.

    So at the end you can show all information you want.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution โœ”๏ธ and give it a thumbs up ๐Ÿ‘

    Best regards
    Denis

    Blog: WhatTheFact.bi
    Follow me: twitter.com/DenSelimovic

8 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    4 years ago

    Hey lherbert501 ,

     

    yes, that's possible.

    You just in the target page have to define the fields that should be passed to the drillthrough page:

    https://docs.microsoft.com/power-bi/create-reports/desktop-drillthrough#set-up-the-drillthrough-target-page

     

    Then you can use the filtered field for the card or title.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution โœ”๏ธ and give it a thumbs up ๐Ÿ‘

    Best regards
    Denis

    Blog: WhatTheFact.bi
    Follow me: twitter.com/DenSelimovic

    • lherbert501's avatar
      lherbert501
      Post Prodigy
      4 years ago

      Hi selimovd ,

       

      Thanks for the reply. 

       

      If there was more than one field though, this would have to be in the case of a measure would it not?

       

      Thanks 

       

      Liam

      • selimovd's avatar
        selimovd
        Most Valuable Professional
        4 years ago

        Hey lherbert501 ,

         

        you can add as many columns as you want.

        Just drag and drop them to the same field as the first one.

         

        If you need any help please let me know.
        If I answered your question I would be happy if you could mark my post as a solution โœ”๏ธ and give it a thumbs up ๐Ÿ‘

        Best regards
        Denis

        Blog: WhatTheFact.bi
        Follow me: twitter.com/DenSelimovic

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  lherbert501 ,

    I created some data:

    Here are the steps you can follow๏ผš

    1. Create calculated column.

    Flag =
'Table'[date]&" "&'Table'[Group]

    2. Click on the Card's Title - fx.

    3. Select Column [Flag].

    4. Result:

    When drillthrough, it will be automatically displayed in the title.

    If you need pbix, please click here.

     

    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