Forum Discussion

Jithinraj2006's avatar
Jithinraj2006
Frequent Visitor
8 years ago

Cross drill between Two matrix tables in Same Report Tab

Hi, Request urgent help on 'Cross drill down' between two Matrix tables in the same tab.  The two matrix tables are using same dimensions but different measures. Requirement is to show it in single...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Jithinraj2006

As tested, using 'Drill filters other visuals' and 'edit interactions' can help if your table has serveral rows.

A basic dataset above format should be

category subcategory1 subcategory2 value
A Aa Aa1 1
A Aa Aa2 2
A Ab Ab1 3
A Ab Ab2 4
B Ba Ba1 5
B Ba Ba2 6
B Bb Bb1 7
B Bb Bb2 8

 

 

Best Regards

Maggie

Jithinraj2006's avatar
Jithinraj2006
Frequent Visitor
8 years ago

Hi Maggie,

 

The had tried the 'drill' feature as mentioned below. But not working as expected.

 

We have two tables here

 

 

when drilling down at first table second table also drill down one level and should look exactly same

 

 

Maybe the feature is not available and is there any workaround possible?

 

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

    Hi Jithinraj2006

    The feature is not completely, as tested, it is possible in my scenario above, but in your scenario, Drill down doesn't work when you drill say first visual and you expect the other visual to similarly drill down on to the next level.

    I suggest you to vote for this idea to help improve power bi.

     

    Best Regards

    Maggie

    • Jithinraj2006's avatar
      Jithinraj2006
      Frequent Visitor
      8 years ago

      Hi Maggie.

       

      I have voted. Thanks for the sujjestion. Hope we get the update soon.

       

      Regards,

      Jithin