Forum Discussion

Ritaf1983's avatar
Ritaf1983
Super User
1 year ago
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...
Need Help
Show and Tell
Tutorial Requests
  • Deku's avatar
    Deku
    1 year ago

    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 

     

     

     

     

     

Deku's avatar
Deku
Super User
1 year ago

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