apply slicer to a table visual particular column

[Anonymous]

Hi,

I have a table visual in which there are 3 measures with sub category name to sort the number. I want to use slicer on one measure and do not want to use on other measure is it possible to do both the things in a single visual table.

[Anonymous · Accepted solution]

Hi  @Anonymous ,

I created some data:

The normal measure results show:

Here are the steps you can follow：

1. Use Enter data to create a table as a slicer.

2. Create measure.

Assigned/In-Progress =
var _select=SELECTEDVALUE(Slicer_Table[Slicer])
var _Assigned=IF(
COUNTX(FILTER(ALL('Table'),'Table'[Group]="Assigned/In-Progress"),[Customer Request Sub]) =BLANK(),0,1)
return
IF(
 _select=1, IF(_Assigned=0,_Assigned+1,_Assigned),_Assigned)

Closed =
var _select=SELECTEDVALUE(Slicer_Table[Slicer])
var _close=
COUNTX(FILTER(ALL('Table'),'Table'[Group]="Closed"),[Customer Request Sub])
return
IF(
    _select=2,_close + 1 ,_close)

Resloved =
var _select=SELECTEDVALUE('Slicer_Table'[Slicer])
var _resloved=
COUNTX(FILTER(ALL('Table'),'Table'[Group]="Resloved"),[Customer Request Sub])
return
IF(
    _select=3,_resloved+10,_resloved)

3. Result:

When the slicer is selected as 1, it affects the value of [Assigned/In-Progress] and does not affect the other two measures.

Best Regards,

Liu Yang

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

[Anonymous]

Hello @Anonymous 

Thanks for the solution,

But it seems long process instead of this I have used ALLEXCEPT function in measure and given the slicer table name and column name with it and it's working same as I expected.

[amitchandak]

@Anonymous , Create an independent slicer and use that in that measure only.

Otherwise you need use all in the measure you do want filter

[Anonymous]

As I have written I am using single table in that there are three measures. For this situation I am asking.

[amitchandak]

@Anonymous , let us say you want to filter a value using slicer and it should only filter closed. So either you should remove the filter from the other two. Or use an independent table and use filter on this column

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE