'Locking' order of categories in graph

[Anonymous]

Hi all,

In my report I have several graphs. I've included a sidebar with filter options as well. When selecting different options in the filters, the graphs change accordingly. However, answer categories move along the x-/y-axis as well (ascending/descending order).

Does anyone know if it's possible to 'lock' the answer categories so as they stay in the default status?

Thanks!

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem with th suggestion of TomMartens ?

If you have answered, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share  your desired output.

Best Regards,

Cherry

[TomMartens]

Hey,

not sure if this idea will meet you requirement:

Order the answer categories to your liking:

https://community.powerbi.com/t5/Desktop/Re-ordering-the-x-axis-values/td-p/267859

Make sure the option "Show items with no data" is activated.

Regards,

Tom