Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I have two date colums Air Departure Date and Hotel Check Inn date and I want a filter that show the next 3 days.
I know you can add the slicer and do relative date and choose next(number of days) but you can only do that one one date value while I have two. Any ideas? Ross
Hi @rosscortb ,
Could you please provide some sample data (exclude sensitive data) and your expected result with screenshot? Thank you.
Best Regards
Rena
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hey @rosscortb ,
I'm not 100% sure if I understand your requirements.
Nevertheless, from what I understand (at least guess to understand) I recommend the following.
Create a separate calendar table, that is not related to your existing table from the screenshot below. Use this calendar table with a slicer.
Based on the slicer selection create a measure that flags the rows that are matching the conditions (return 1 if the conditions are matched otherwise return 0), you can then use this measure inside a visual level filter to show the matching rows.
If you need more assistance, please create a pbix with sample data, but still reflects your data model, upload the file to onedrive or dropbox and share the link.
Regards,
Tom
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |