Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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 

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        Arul
        Icon for Super User rankSuper User
        4 years ago

        Hi Anonymous ,

         

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

         

        Thanks,

        Arul

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.