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 All,
I have a measure value that contains with the Wt. Avg like - 1, 2.2, 3, .......1000 values
Now, my end user wanted to select in the slicer with any of the above value and dashboard should filter accordingly.
Can anyone help me how to acheive this. I know measure cannot be put into slicer.
Thanks,
Akhil.
Try the below thread for workaround:
https://community.powerbi.com/t5/Desktop/Measure-as-Slicer-Workaround/td-p/611781
Hi @Akhil_1411 ,
Will you consider using filter to replace the slicer just like below screen shot?
Best Regards
Rena
Hi @v-yiruan-msft ,
Thanks for your reply, but i want that to be on the dashboard not on the filter section.😑
Regards,
Akhil.
You can create a What If parameter and then use the SELECTEDVALUE() from it in a new measure that returns blank when your original measure does not meet the criteria.
NewMeasure = var __wtavg = [OriginalMeasure]
Return IF(__wtavg<SELECTEDVALUE(Slicer[SlicerValue]), BLANK(), __wtavg)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @mahoneypat ,
Thanks for your reply. But, the logic which u have suggested it just act as a measure.
But, in my dashboard i do have lot of different measures and dimensions as well. If i select any value in that(referring to values) the dashboard should be filtered accordingly.
Thanks,
Akhil.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |