Drill through by other visual

[Mengeltje]

Hi everybody,

In a report I use the decomposition tree and a column chart. Both with the same values.

When I click on an item in the decomposition tree the chart changes to the correct values. Only thing is that the original values are still visible only more transparent and the values belonging to the clicked item are shown as a part of that. Like underneath example.

Is it possible that when I click on the item the chart is only showing the values belonging to that item, so not the transparent amounts.

Thanks for your advice. 

[amitchandak · Accepted solution]

@Mengeltje , Change visual Interact to filter from the fill. Refer for steps

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

or my video: https://www.youtube.com/watch?v=GIfRKzhMaR4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=13

[selimovd · Accepted solution]

Hey @Mengeltje ,

you can do that by changing the interaction from cross highlight to cross filter.

Check the small video I made:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[amitchandak · Accepted solution]

@Mengeltje , Change visual Interact to filter from the fill. Refer for steps

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

or my video: https://www.youtube.com/watch?v=GIfRKzhMaR4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=13