The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi there,
How can i apply slicer using multiple measurements fields
In the attached pic, I need to apply filter using "impressionn, Reach and amount spent" these are measurements
I need apply a filter such that if I select impressions only impression should show up.
Thanks
Hi, @Anonymous ;
I agree with amitchandak's idea.
First you could download Tabular Editor and install it.
https://docs.tabulareditor.com/
Secondly you could use Calculation groups.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please refer the below steps:
1. Create your measures
2. Create table for your measure objects using enter data in home tab like below.
3. Then create another measure like the below to use your measure name in the slicer where it is actually getting connected to your original measure values.
Measure Selection= SWITCH(TRUE(),SELECTEDVALUE('Measure selection'[ID])=1,[Profit M],SELECTEDVALUE('Measure selection'[ID])=2,financials[Sales])
4. Finally use the column name from the new table in the report to filter the measure.
Thanks,
Arul
Hi Arul,
In my case my data already contains the measurement values,
Can you please explain, if i create a new table how do i map or connect it to my measurements.
ik its a dumb doubt I just started my power BI journey.
Hi @Anonymous ,
Create measures for your calculations and use them in the above scenario.
Thanks,
Arul
@Anonymous , Best is the calculation group. refer if this can help: Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
80 | |
77 | |
46 | |
40 |
User | Count |
---|---|
149 | |
115 | |
67 | |
64 | |
58 |