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

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