dynamic sort order within a parameter

[fjjpeeters1976]

Hi all,

I created a parameter that allows me to have the user choose a hierarchy (either based on accounts, or on function or on entity) and with some tweaking it works nicely. So next what I did was to see if people could select multiple hierarchies, so that within an account they could see from which entity or function the costs comes. Also this works nicely. However I am currently limited to the order of the hierarchies, so the user always first sees the account hierarchy. I was wondering, is there a way to make this dynamic so that the user could for example first choose the entities, than chooses the accounts and after that the functions? 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

The hierarchy in the matrix visualization changes based on the selection order from the field-parameter-slicer.

[fjjpeeters1976]

hi Jihwan, 
Thanks for your reply. I can see that in your example it works and this is exactly what I try to achieve. I think the issue that I have is that I first do the grouping and after it the parameter selection. If I only do the parameter selection I am achieving it as well.