Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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

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


Anonymous
Not applicable

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





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

Proud to be a Super User!


LinkedIn


amitchandak
Super User
Super User

@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

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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