Forum Discussion

neek05's avatar
neek05
Frequent Visitor
3 years ago

Drill through from selected value in matrix

Hi,

 

I'm trying to create a drill through from a Card visual. The card value for the drill through should be the selected value in the matrix.

I'm using this measure in the card and in the drill through page: 

 

SelectedValue = SELECTEDVALUE('Table'[FromRecord])

 

 

In the drill through page the value passed in the card is correct but I'm getting the incorrect row in the matrix. I want to filter the row 2, not the row 4. 

I think I'm making some silly mistake in the measure, but I'm new to Power Bi, so I have no idea. Also, I think I can achieve the same result if a duplicate the table and create a relationship between them, but I'm trying to avoid that. I'm attaching an example. Can anyone help me with this? Thank you! 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello neek05 ,

     

    I think the value you are getting in drill through is correct as in the 1st image you have selected the row having the RecordNumber value as 4 and RecordNumber value as 2 which is matcing in 2nd image.

     

    Please let me know if my understanding is not correct.

    • neek05's avatar
      neek05
      Frequent Visitor
      3 years ago

      Thank you, 

      But, could it be possible to get the value of row 2 (RecordNumber =2, Status= A), instead of RecordNumber=4, Status=C?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hello neek05 ,

         

        Then you will need to drill through 2nd row becuase drill through applies the filter to the page from which it is been navigated.

         

        Thank You!