Forum Discussion

aszpic's avatar
aszpic
Frequent Visitor
8 years ago
Solved

An issue with slicers. Help please!

Hello everyone,

 

I've had an issue regarding slicers that I couldn't solve.

 

I have a simple table, let's say with a single column called ID. Then I have 2 different slicers that filter that column (ID) (in the real case I must have different slicers filtering the same column because os presentation issues...).

 

The problem is that the result table I need (the filtered ID column) needs to INCLUDE the results of both slicers.

 

This is the most precise example I could draw in Excel: https://imgur.com/a/k8Abz 

 

 

I tried using a calculated column with UNION,  SUMMARIZECOLUMS and ALL functions but couldn't hit the result...

 

Help please?

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI aszpic,

     

    First of all, current power bi not support to use slicer/filter to create a calculated column/table.

    In addition, power bi also not support create multiple slicers from same column to apply filter on original table.

    For your requirement, you need to create mutiple selector tables as the source of slicer and writea measure, and drag it to filter to enable filter effect.

     

    Sample:

    Tag = 
var _current=SELECTEDVALUE('Table'[Value])
var _select1=ALLSELECTED(Selector1[Value])
var _select2=ALLSELECTED(Selector2[Value])
Return
IF(_current in _select1 || _current in _select2,"Y","N")

     

    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI aszpic,

     

    First of all, current power bi not support to use slicer/filter to create a calculated column/table.

    In addition, power bi also not support create multiple slicers from same column to apply filter on original table.

    For your requirement, you need to create mutiple selector tables as the source of slicer and writea measure, and drag it to filter to enable filter effect.

     

    Sample:

    Tag = 
var _current=SELECTEDVALUE('Table'[Value])
var _select1=ALLSELECTED(Selector1[Value])
var _select2=ALLSELECTED(Selector2[Value])
Return
IF(_current in _select1 || _current in _select2,"Y","N")

     

    Regards,

    Xiaoxin Sheng

    • aszpic's avatar
      aszpic
      Frequent Visitor
      8 years ago

      Oh thanks.

      My primitive solution was to copy the "selector" column multiple times, put one of them in each slicer and create a calculated table with UNION functoin of the tables as my result table...