Slicer For Multiple Measurements for Bar charts

[Anonymous]

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

[v-yalanwu-msft]

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]

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

[Anonymous]

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. 

[Arul]

Hi @Anonymous ,

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

Thanks,

Arul

[amitchandak]

@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