The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi, I want to use measure in the slicer. And that measure consist of another two measures. Please let me know how to acheive this.
Thanks,
Amruta
Hi @Anonymous ,
1. The slicer does not support measures, but you can use them in filters and then save them as bookmarks to achieve the same effect by switching bookmarks.
2. Or you can create a calculate column instead of a measure.
3. If you want to switch between the two measures, you can try the latest preview function field parameter.
Let report readers use field parameters to change visuals (preview)
Field Parameters in Power BI - Microsoft Power BI Community
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
@Anonymous , Dynamic Segmentation
Example 1
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Example 2
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
More
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://youtu.be/CuczXPj0N-k
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
21 | |
20 | |
12 | |
11 | |
7 |