Forum Discussion

newpbiuser01's avatar
newpbiuser01
Icon for Helper V rankHelper V
4 years ago
Solved

Dynamically change matrix visual value

Hello, I have created a matrix visual using the Fields parameters to allow a user to dynamically change the rows and columns in the table. I would typically drive the value field for the matrix with...
Need Help
  • itchyeyeballs's avatar
    itchyeyeballs
    4 years ago

    If you are using the new field parameters you can use this to create a new measure that dynamically selects a measure or column

    xP_param1 = 
SWITCH (
    SELECTEDVALUE ( xP_Param[xP_Param Order] ),
    0, [Measure1],
    1, [Measure2],
    2, [Measure3],
    3, [Measure4],
    4, [Measure5]
)

     you can then use this in the values section to give you the right calculation for the selection 

    It uses the sort order column to link a measure to each parameter option.

itchyeyeballs's avatar
itchyeyeballs
Icon for Impactful Individual rankImpactful Individual
4 years ago

If you are using the new field parameters you can use this to create a new measure that dynamically selects a measure or column

xP_param1 = 
SWITCH (
    SELECTEDVALUE ( xP_Param[xP_Param Order] ),
    0, [Measure1],
    1, [Measure2],
    2, [Measure3],
    3, [Measure4],
    4, [Measure5]
)

 you can then use this in the values section to give you the right calculation for the selection 

It uses the sort order column to link a measure to each parameter option.