Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 user selects the measures the matrix changes according to the selection. This works fine when two or more measures are selected in the Parameter measure slicer, but when only one measure is selected it only shows the values but not the selected measure name.
Is there any way to show the selected measure name in the matrix when only one meaure parameter is selected.
Thanks in advance.
Solved! Go to Solution.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |