Forum Discussion
Drill through by other visual
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.
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
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 regardsDenisBlog: WhatTheFact.bi
2 Replies
- selimovd
Most Valuable Professional
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 regardsDenisBlog: WhatTheFact.bi - amitchandak
Super User
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