Change x-axis when i change my filter

[Anonymous]

Hello everyone !

I got 2 filters in my bi :

- mois (month)

- BO (Place)

I would like to have 1 unical graph which displays :

- the number of PST (Npst is a value : see below on the histogram) by place (BO) when month is filtered

- the number of PST by month (mois) when BO is filtered.

The result is this but i would like to gather it on the same graph.

If someone has tips or solution i take 🙂

Thanks !!!

[Alf94]

Hi @Anonymous ,

You could create a hierarchy in your histogram. By default the higher level would be NPST by month, and when you drill down on a month you will see NPST by BO.

If I answered your question, please mark my post as a solution.

Best,

[Anonymous]

Yes i saw this but is it possible to automate it without clicking to move on to the second graph?

[Alf94]

At first sight I think not, but maybe someone will have an idea to help you.

[v-yueyunzh-msft · Accepted solution]

Hi , @Anonymous 

According to your description, you want to dynamicly change the x-axis in your visual by your slicer.

First of all, the current method of dynamically switching the X-axis dimension in Power BI is "Field parameter".

We can create the field parameter like this:

And then we can put the field on the viusal and we can use the slicer to change the x-axis:

And for your second need , in my experience , just like the @Alf94  said, there seems no way to make the slicer selected when the other slicer selected.So , you need to first select the 'Parameter' slicer to select which dimension you want to see and then you can filter the [BO] and [miso] in your slicer !

For this , you can also refer to the document about "Field parameter":

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

What are Field Parameters in Power BI? | phData

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly