Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Slicer For Multiple Measurements for Bar charts

Hi there, 

How can i apply  slicer using multiple measurements fields

 

Akmal_0-1648624472736.png

 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

5 REPLIES 5
v-yalanwu-msft
Community Support
Community Support

Syndicated - Outbound

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.

https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=power-bi-premium-current&preserve-view=true

 


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.

Arul
Super User
Super User

Syndicated - Outbound

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.

Arul_0-1648626138516.png

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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


avatar user
Anonymous
Not applicable

Syndicated - Outbound

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. 

Syndicated - Outbound

Hi @Anonymous ,

 

Create measures for your calculations and use them in the above scenario.

 

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


amitchandak
Super User
Super User

Syndicated - Outbound

@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 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)