Forum Discussion

mohan_g_das1986's avatar
mohan_g_das1986
Helper III
6 years ago
Solved

Using Treemap Visual how to filter a Matrix table in another sheet of Dashboard

Hi - I have 2 sheets of the report, one will give me products & their performance using the treemap visual. Next sheet i have the list of partners & their sales out detailed level (with address). Cur...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, mohan_g_das1986 

     

    You may uncheck the filtered item in the following screenshot.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi mohan_g_das1986 ,

 

BAsed on your description, if you select something in Treemap visual, the other matrix visual should get filtered or highlighted.

Does both of your visuals use fields from same table?

If they use fields from different tables are they related somehow?

 

Have you checked interactions in Power BI?

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

 

It could be possible that your interactions on matrix visual are off against treemap visual.

 

Thanks,

Pragati

mohan_g_das1986's avatar
mohan_g_das1986
Helper III
6 years ago

Data is from the sample table, the only thing is they are on the different page of the dashboard. A different view, one product only & Other partners who have those products. Is there any way in the treemap view when I select the product which has 100%, in the next page I should see all the partner who has that sku

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi mohan_g_das1986 ,

     

    If the treemap and other visual are on different tabs, then I am afraid you can filter the other tab based on treemap selection. You may you a drill-through feature.

     

    Thanks,

    Pragati