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~