Forum Discussion
Automatic drill down based on slicer selection
Hi Dimitris_Kats ,
You can refer to below solution.
#1. when there is no selection in the slicer to display in the chart the brand
#2. if there is a brand selected in the slicer to display automatically the related models in the bar chart
Demo - Automatic drill down based on slicer selection.pbix
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
It can be implemented, but there is no generic solution, it needs to be designed on a per object basis.
Generally it is a matter of adding additional filtering logic within the measure, or adding visual filters (controlled with the measure).
For example, you can refer to the following example:
Default state:
Interaction state:
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
It can be implemented, but there is no generic solution, it needs to be designed on a per object basis.
Generally it is a matter of adding additional filtering logic within the measure, or adding visual filters (controlled with the measure).
For example, you can refer to the following example:
Default state:
Interaction state:
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
Thank you so much xifeng_L for your answer. Unfortunately I don't use the same fields ( brand and model) in the matrix. I use other fields . I tried your solution but I couldn't make it work. I also tried to creat a relationship to solve the problem but still couldn't fix it. Could you please help me out with that?? 🙏
As stated above, there is no universal approach to this and it needs to be tailored to different scenarios.
You can learn my solution idea above and apply it to your scenario.