Forum Discussion
Switch function not working with a slicer
Hi MichaelNiederer ,
The problem is that you have created a column on your model instead of a measure you create the following measure:
Prev_Selection_SwitchCG _1 = SWITCH(TRUE(), [NetSumPrev] >= MIN(CategoryDelNotes[Min]) && [NetSumPrev] < MAX(CategoryDelNotes[MAXREVISED]), 1)Now you should be able to get the result you need.
Be aware that since your max value is blank I created a new column replacing blank by 9999999999
Now if you use this measure on your visual you are able to get the expected result:
If you just filter out the blanks you get the following result the bottom table is the one with the filter applied:
Please see file attached.
Hi, sorry for the delay, i needed some time to prepare example data manually.
So i have some sales table (in original with DateTime column - so i could also use the PreviousDate Filter as a slider it seems - but seems similar with only Date at least) and a report where i display unique elements "DealerId + CustomerNr" (along with a summary of product group sums).
My goal is to limit/filter the report to Combinations where Previous Date SalesSum is within some range - so i can filter important customers which i loose completely e.g. I tried with a switch statement to NetSum Previous Year like suggested but this does not filter anything.
Is this not working properly, because mixing with product groups in the report? I think i am missing something.
example report with demo data:
Thank you for your help.
Kind regards
Community SupportHi MichaelNiederer,
To make the slicer work you need to have the field from the disconnected table in the visual as well as the slicer.
Check below Pbix file for reference:
Thank you.
- MFelix
Super User
Hi MichaelNiederer ,
The problem is that you have created a column on your model instead of a measure you create the following measure:
Prev_Selection_SwitchCG _1 = SWITCH(TRUE(), [NetSumPrev] >= MIN(CategoryDelNotes[Min]) && [NetSumPrev] < MAX(CategoryDelNotes[MAXREVISED]), 1)Now you should be able to get the result you need.
Be aware that since your max value is blank I created a new column replacing blank by 9999999999
Now if you use this measure on your visual you are able to get the expected result:
If you just filter out the blanks you get the following result the bottom table is the one with the filter applied:
Please see file attached.
Thank you very much MFelix, now i understood how to do this 😉
So you will need to add a filter to the visual, then this works.