Forum Discussion
Solved
Power BI Matrix: Dynamic Percentage Calculation Across Hierarchical Levels Using Field Parameters
Hi 🙂
I have a matrix visual analyzing employee costs based on three dimensions:
Site
Department
Gender
Each dimension is selected dynamically using Field Parameters.
My goal is to di...
I had a look
selectedParameter = TOJSON( Parameter )
Using this we can see the parameters being applied. The problem is the result of the measure is always in the same order, even when the visual has memory of the order of selection.
If you look at the query you can see in the query that the visual knows the order. But can't see anyway to surface the filter ordering. Had a look at SQL post on Field Parameter, and there is already a comment that confirms
Hi Ritaf1983 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.