Forum Discussion

BossCo's avatar
BossCo
Icon for Helper II rankHelper II
6 years ago
Solved

Column depending on a measure or slicer.

Hi everyone! In my model, I have a dimension table with three columns: item, begin date, end date. I have a slicer for the items, with multiple selection allowed. I need to create a slicer for the dat...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago
    Hi BossCo ,
     
    Unfortunately, measure cannot be used directly as a slicer and cannot use the values of multiple columns in the same slicer.
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago
Hi BossCo ,
 
Unfortunately, measure cannot be used directly as a slicer and cannot use the values of multiple columns in the same slicer.
 
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BossCo's avatar
BossCo
Icon for Helper II rankHelper II
6 years ago

Ok thanks, I'll create two card visuals with the begin and the end date and a warning:

"Please, for coherent data DO NOT SELECT dates outside of this range".

 

😂

 

Thanks!