Forum Discussion
Shows Data Based on Date
Hey everyone,
I want to create a report that shows all active promo based on date slicer.
Right now it shows only promo that has [End Date] before 10 January 2020, because I create the relationship between 2 tables, 'All Promo Details' and 'Date', based on [End Date] column.
Actually, there are several promos that are currently active right now. How can I show the promos that currently active based on start date and end date in date slicer? Its something like this, [Start Date] =< [start date slicer] and [end date slicer] >= [End Date]. Please help me.
6 Replies
Change Cross filter direction of Relationship to "Both" as per your screen shot.
Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!
It still shows the same result. I edited my question so maybe it will give you a better understanding about my problem.
I have blog active employees. Seems similar problem. Refer
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Wow, it sure like a high-level report. I need and will learn about it first. Thanks amitchandak
Hi hilmandenis ,
You may create measure Filter1 like DAX below, , then put the Filter1 in the Visual Level Filter of table visual which displays [Promo Name] and other fields, setting Filter1 as "is not blank".
Filter1= Var FromDate = CALCULATE(MIN(Date[Date]),ALLSELECTED(Date[Date])) Var ToDate = CALCULATE(MAX(Date[Date]),ALLSELECTED(Date[Date])) Return IF(MAX('ALL Promo Details'[Start Date])>=FromDate &&MAX('ALL Promo Details'[End Date])<=ToDate, 1, BLANK())Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi hilmandenis ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
