Forum Discussion

PBIfanatic's avatar
PBIfanatic
Helper V
6 years ago
Solved

Same column, multiple filters

Hi,

Is it possible to create multiple filters from the same column and use the input from both the filters to feed the chart. So its effectively the same column in the axis of the chart but the selection is coming from 2 filters. I can use interaction to isolate the selections from each filter. thanks 

Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi PBIfanatic ,

    We can create a measure to meet your requirement.

    The measure calculate the sum total between [Slicer_value 1] and [Slicer_value 2].

     

    Slicervalue total = 
var _selected1 = VALUES('Slicer 1'[Group])
var _selected2 = VALUES('Slicer 2'[Group])
var _value1 = CALCULATE(SUM('Table'[value]),FILTER('Table', 'Table'[Group] in _selected1))
var _value2 = CALCULATE(SUM('Table'[value]),FILTER('Table', 'Table'[Group] in _selected2))
return
_value1 + _value2

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

9 Replies

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Community Support
    6 years ago

    Hi PBIfanatic ,

     

    We can create two tables and two measures to meet your requirement.

    We create a sample, and want to see both selections have performed over time.

     

    1. Create two tables that contain the distinct field you want to add a slicer. For the example, we want to add the GROUP field in slicer, so we need to create two Group tables.

     

    Slicer 1 = DISTINCT('Table'[Group])
    Slicer 2 = DISTINCT('Table'[Group])

     

            

     

    2. Then we create a line chart based on two measures.

     

    Slicer_value 1 = 
var _selected = VALUES('Slicer 1'[Group])
var _value = CALCULATE(SUM('Table'[value]),FILTER('Table', 'Table'[Group] in _selected))
return
_value
    Slicer_value 2 = 
var _selected = VALUES('Slicer 2'[Group])
var _value = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[Group] in _selected))
return
_value

     

     

     

    If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?

    It will be helpful if you can show us the exact expected result based on the tables.

     

    Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • PBIfanatic's avatar
      PBIfanatic
      Helper V
      6 years ago

      Thanks v-zhenbw-msft , thats awesome.

      Its very close to what I need, is there a way to show the selected dimensions in the chart?

      If I have a single selection from Slicer 1 and I select 3 from Slicer 2, is it possible to show all these 4 selections as separate lines in the chart?

      • v-zhenbw-msft's avatar
        v-zhenbw-msft
        Community Support
        6 years ago

        Hi PBIfanatic ,

        We can create a measure to meet your requirement.

        The measure calculate the sum total between [Slicer_value 1] and [Slicer_value 2].

         

        Slicervalue total = 
var _selected1 = VALUES('Slicer 1'[Group])
var _selected2 = VALUES('Slicer 2'[Group])
var _value1 = CALCULATE(SUM('Table'[value]),FILTER('Table', 'Table'[Group] in _selected1))
var _value2 = CALCULATE(SUM('Table'[value]),FILTER('Table', 'Table'[Group] in _selected2))
return
_value1 + _value2

         

         

        If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

        BTW, pbix as attached.

         

        Best regards,

         

        Community Support Team _ zhenbw

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    PBIfanatic why would you do that, why not one slicer with multiple selections?

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

    • PBIfanatic's avatar
      PBIfanatic
      Helper V
      6 years ago

      parry2k  Its a requirement to show it in 2 filters...to have one selection as the core product and then other ones as a comparison.

      Is this possible ?

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        PBIfanatic yes you can surely have multiple slicers from the same column.

         

        I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

        ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡