Set Values For Slicer

[atat0105]

Hello everyone,

I have a column which defines each row like below.

Column =IF(V_OKM_0[Periyod]<601;"Active";"Passive")

then, I show percentage of "Passive" on a card.

Measure = CALCULATE(SUM(V_OKM_0[Pasif])/(SUM(V_OKM_0[Aktif])+SUM(V_OKM_0[Pasif])))

But I would like to have a slicer includes values of 301, 601, 901 instead of a set value like 601 in example above. Is it possible to do?

If slicer is 601,

Periyod - Column

400 - Active

700 -  Passive

1000 - Passive

So, result is %66

If slicer is 901,

Periyod - Column

400 - Active

700 -  Passive

1000 - Passive

So, result is %33

Thanks a lot.

[Anonymous · Accepted solution]

Hi @atat0105,

It is possible, you can refer to below steps:

Tables: Sheet1,sheet2.

 

Measures:

Sheet2.

Select value:
Select value = if(HASONEVALUE(Sheet2[Amount]),VALUES(Sheet2[Amount]),BLANK())

Sheet1.

Get the status of select values:
Active Status = IF(max([Amount])<[Select value],"Active","Passive")

Percent of passive:
Percent of Passive = COUNTAX(FILTER(ALL(Sheet1),[Active Status]="Passive"),[ID])/COUNTROWS(ALL(Sheet1))

Create visuals.

Table:

 

slicer:

card:

 

Result:
  

Regards,
Xiaoxin Sheng