Forum Discussion

NidhiBhusari's avatar
NidhiBhusari
Helper IV
4 years ago

Drill through

Hello All,
Requirement :- when drilling through a particular field from a grid the lower grid should get filter out and display only the field using which drill through is done.
 
I have implemented drill through in Power BI(right side of image) but was unable to achieve the remaining part as described above

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    NidhiBhusari , Based on what I got. If you want to Drill and control the measure display, then create a calculation group, that will convert the measure into dimension and will allow you to filter

     

     

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

    • NidhiBhusari's avatar
      NidhiBhusari
      Helper IV
      4 years ago

      Hi amitchandak , I want to achieve the drill through the same as shown in the picture to the left. i.e on whichever row I am clicking to drill through only that row should get displayed in the below grid.