Forum Discussion
Slicer Set Value
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.
Hi Atat0105,
You will need to use a disconnected table here.
Instead of "hardcoding" the IF in your column to <601 you can pass a slicer value through.
Click "Enter data" and build a table like below/ the measure shown in the formula bar.
Once you do this pass that measure into the calculated column like so:
When you are using disconnected tables you allow yourself to pick what you want to slice on. Connect the tables within Power BI to filter correctly. Once you select a value from that disconnect table it will pass that value into the rest of your functions.
Hope this helps,
Christian
2 Replies
Hi Atat0105,
You will need to use a disconnected table here.
Instead of "hardcoding" the IF in your column to <601 you can pass a slicer value through.
Click "Enter data" and build a table like below/ the measure shown in the formula bar.
Once you do this pass that measure into the calculated column like so:
When you are using disconnected tables you allow yourself to pick what you want to slice on. Connect the tables within Power BI to filter correctly. Once you select a value from that disconnect table it will pass that value into the rest of your functions.
Hope this helps,
Christian
Can you provide some sample data so that we can mock this up?
