Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Activating Date slicer by USERELATIONSHIP function

Hello!
In my fact table I have two date columns; creation_dateTime and Delivery_dateTime.
In need to use two date slicers in my report for both date columns. 
The Delivery_dateTime column has non active relationship with my dim_date table. 
How can I activate the Delivery_DateTime column and to use it in a  licer and to filter all report?
 
I created this query but it didn't work.
 
Delivery_Date =
CALCULATE(DISTINCT(Fact_Orders[od_Delivery_DateTime]),USERELATIONSHIP(Fact_Orders[od_Delivery_DateTime],Dim_Dates[Date]))

 

Any suggestions?
Thanks in advance!
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Anonymous,

     

    Try measure as:

    Delivery = 
CALCULATE (
    DISTINCT(Fact_Orders[od_Delivery_DateTime]),
    ALLSELECTED ( Dim_Dates[Date] ),
    USERELATIONSHIP(Fact_Orders[od_Delivery_DateTime],Dim_Dates[Date])
)

     You can also refer this related post:

    https://community.powerbi.com/t5/Desktop/Comparar-Per%C3%ADodos-Distintos/td-p/2024811

     

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous if you want two date slicers, you need to have another date table in your model which has a relationship with the delivery date. Userelationship function is useful when you have a single slicer and want to visualize data on both on creation date and delivery date.

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi Anonymous,

     

    Try measure as:

    Delivery = 
CALCULATE (
    DISTINCT(Fact_Orders[od_Delivery_DateTime]),
    ALLSELECTED ( Dim_Dates[Date] ),
    USERELATIONSHIP(Fact_Orders[od_Delivery_DateTime],Dim_Dates[Date])
)

     You can also refer this related post:

    https://community.powerbi.com/t5/Desktop/Comparar-Per%C3%ADodos-Distintos/td-p/2024811

     

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!