Forum Discussion
Filtering chart by chart and by slicer at the same time - issue
Hi Mikolajszewczyk, it's all about data modelling. It would take too long to explain in detail, but I'm attaching the working PBIX file for you to study. 😉
Good luck with your project!
Super UserHello,
I think that the simplest way to fix this is to stop letting the first decomposition tree filter the second one directly. Instead create a small disconnected table that only stores the selected path values and use a measure with TREATAS to apply that selection logically,
this way the slicer and the path selection are combined inside the measure, not by the visual engine, Power BI will then calculate percentages correctly even when some path and characteristic combinations do not physically exist.
Hey Daniele
Could you elaborate how such disconnected table should look like and how to use treatas in this context? I've never used treatas function and have no idea how to put your suggestion into reality