Forum Discussion
kdendukuri
4 years agoNew Member
Help with slicer
I have Customer key, Officekey and Datetrx and DatePurge, Amount. I need my report with the below conditions 1. Datepurge is null or Datepurge >= VariableDate (a Date that user selects) 2. Datet...
v-chenwuz-msft
Community Support
4 years agoHi kdendukuri ,
You need create a new table via values(table[Datepurge]) for the slicer just giving Variable to the measure and not participating in the filter context. The new table should have no relationships with this fact table. It is much better to get variables from the slicer via max() or min() than selectedvalue() to avoid blank.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.