- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Slicer For Multiple Measurements for Bar charts
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
Create measures for your calculations and use them in the above scenario.
Thanks,
Arul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-20-2024 03:46 PM | |||
07-14-2024 08:08 PM | |||
10-10-2024 11:54 AM | |||
08-26-2024 08:09 AM | |||
07-12-2024 03:03 AM |
User | Count |
---|---|
137 | |
107 | |
85 | |
59 | |
46 |