Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a slicer or filter from a Measure

I am trying to create a slicer or filter for a measure   My source data only has a "Billing Start date" and no "Billing Finish Date" we only have the term of contract i.e. 12, 24, 36, etc   I hav...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi Anonymous 

    Based on your explanation, I create a sample file, you can take it for reference. See sample file attached below.

    Besides, the easiest way is to create a column,

    In Range Col = IF('All Bookings'[Billing Finish Date]<=TODAY(),"Expired","Booked")

    Then, drag this column into the slicer:

    Result:

    Best Regards,

    Community Support Team _ Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Community Support
5 years ago

Hi Anonymous 

Based on your explanation, I create a sample file, you can take it for reference. See sample file attached below.

Besides, the easiest way is to create a column,

In Range Col = IF('All Bookings'[Billing Finish Date]<=TODAY(),"Expired","Booked")

Then, drag this column into the slicer:

Result:

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Works like a dream thank you 🙂