Forum Discussion

Prabha45's avatar
Prabha45
Helper III
2 years ago
Solved

Field Parameter - Single selection

Hi, I have created a field parameters with the measures in the report and added the parameter as a slicer and as values to a matrix. I have enabled "switch value to rows groups in the matrix. When a...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Prabha45 

    After testing, When you select only one option in a field parameter, it does only return the value, not the name of the measure,maybe you can consider use another solution instead of use field paramater of the visual.

    1.You can create a new table and put the measure names to the table, then put the coumn to the row of the matrix and don't change the column field of the matrix.

    e.g I have test1 and test2 measures

    2.Then create a new measure. and put it to the value of the matrix.

     

    Measure= SWITCH(TRUE(),SELECTEDVALUE('Table (2)'[Type])="test1",[test1],SELECTEDVALUE('Table (2)'[Type])="test2",[test2])

     

    3.Then create a slicer, and put the type field to the slicer. then when you select it, it will return the related value and include the name.

    Output

     

    Best Regards!

    Yolo Zhu

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