Forum Discussion
Slicer Set Value
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
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