Forum Discussion

Pbiuserr's avatar
Pbiuserr
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

My card doesn't drill through table

Hello,

I have a card with a measure in it. I've set two drillthrough pages - one with visuals, one with table

 

Lets say the number of count in card is 26. When I drill through visuals its good - displaying only valus of 26 on visuals, however when it comes to table - it shows entire table, not filtered by these 26 from card on which I used drilldown

 

is there particular reason why? unfortunately I can't share the data

  • Hi,

    I figured out that because I've added IF(ISBLANK ( <MY MEASURE>), N/A, <MY MEASURE>) it never gives me blank but N/A so Power BI sees it as a value

     

    and because of that it didnt worked. I've solved my problem

3 Replies

  • Hi Pbiuserr ,

     

    Did you place the measure you are using on the card on the rows of the table?

    • Pbiuserr's avatar
      Pbiuserr
      Icon for Post Prodigy rankPost Prodigy

      Hi,

      I figured out that because I've added IF(ISBLANK ( <MY MEASURE>), N/A, <MY MEASURE>) it never gives me blank but N/A so Power BI sees it as a value

       

      and because of that it didnt worked. I've solved my problem

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User

        Hi Pbiuserr ,

         

        Don't forget to mark the correct answer so it can help others.