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 sele...
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.

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.⚡

  • PBIfanatic's avatar
    PBIfanatic
    Helper V
    6 years ago

    parry2k  thanks!

    How can I show both the selections in a single chart, lets say a line chart. I need to have both of the selections to show in legend. I have a measure and a time dimension as well, so this needs to fit in the legend and I need to see how both selections have performed over time.