Forum Discussion
Field Parameter - Single selection
- Anonymous2 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.
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.