Automatic drill down based on slicer selection

[Dimitris_Kats]

Hello dear members.

I need your help.

I have a hierarchy with brand and model in my table. I have created a bar chart with brand in the x axis and the sales amount in the value. I have also a slicer with the hierarchy Brand, model. 

What I want to achieve is, when there is no selection in the slicer to display in the chart the brand. But if there is a brand selected in the slicer to display automatically the related models in the bar chart. 

I don't know if it is possible to have an dynamic drill down 

Thank you very much 

[xifeng_L · Accepted solution]

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~

[Dimitris_Kats]

@xifeng_L I really appreciate your help!! Thank you very much. 

Is it too much to ask for an example with unrelated fields in the matrix??

[Dimitris_Kats]

@xifeng_L  the only issue now is that I have Lost the possibility to filter the matrix I have in the same page. When I select a brand or model from the bar chart the matrix remains the same. Is it possible to keep that interaction? 

[xifeng_L · Accepted solution]

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~

[Dimitris_Kats]

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?? 🙏

[xifeng_L]

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.

[xifeng_L · Accepted solution]

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~

[Dimitris_Kats]

Hi @xifeng_L 

Is it possible to add another level?

I need to go from level 1 to level 2 and from level 2 to level 3.

Is this possible?

Thank you very much 

[Dimitris_Kats]

@xifeng_L thank you so much. It worked perfectly 🙂