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.
Hello Prabha45
Based on your explanation above.It should not happened. It will be great if you can post your pbix file with some dummy data. It will help us to investigate in deatil. I have tried with my pbix, and it is returning the expected result.
Let me know if t works or not.
Regards
sanalytics
If it is your solution then please like and accept it as solution
Hi sanalytics,
Thanks for your reply. I have added the field parameters as values and made them rows in the matrix. Can you add regions in columns and parameter in values and change them to rows option(format visual - values) and check.
Regards,
Prabha