How to change field parameter sort based on selection?

[Anonymous]

Hi community,

I'm currently trying to find a way to automatically change the sort order of a dimension. In my data, there are two kinds of dimension tables. If the 'normal' dimension is selected via the facttable, I want my visual to sort on the order of that dimension. This works just fine. But in my data there is also another 'alternative' type of dimension, where the sort order is a bit different. If this one is selected, I want to change my visual to the order of that alternative dimension. This is where the challenge is. 

I want to do this dynamically. The way I tried to do this was via field parameters & relationships. Here is an example, where I created a field parameter of the two dimensions I just talked about (these would be Nummer & Nummer2). I also connected the field parameter table with the fact (Coups), via the ARGeenAR field (custom field I added). This field tells if the selected data is about a normal or alternative dimension.

My thought was: if the reportdata is filtered on a normal fact, this would automatically filter the field parameter to the normal row. Thus, it should automatically change my visual to the normal dimension. The same way as it would if I selected the alternative data in my fact.

However, the problem is that it doesn't act the way I intended. When I drop a slicer of the field parameter in my report and change some selections, I see that the field parameter is being filtered correctly. But the visual where I use this field parameter is not responding to it... The field parameter itself doesn't change, just like the sort order.

Does anyone know a solution to this? 

[Anonymous]

Hi @Anonymous ,

Please refer to the posts.

Sort Visual on Field Parameter - Microsoft Power BI Community

Solved: Dynamic measure that changes based on field select... - Microsoft Power BI Community

Solved: Dynamically Change Field Values Standard Table bas... - Microsoft Power BI Community

Best Regards
Community Support Team _ Polly

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