Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey there,
I am looking to create some date filters.
I would like to create a new table in my calendar with filters I cvan check off to select a date period.
ending up like this:
Dateview
7 days
14 days
30 days
90 days
180 days
I used a tutuorial to get a Yes / No on the current date and thought I could use something simular to create this date filter
So what I was thinking was something like (which I know is wrong but you get the idea):
Solved! Go to Solution.
Ok I ended using this instead:
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
I didn't know it existed and it works great!
I appreciate your assistance before.
Hi,
I'm just thinking out loud... I added this as a calculated column to my Date Dimension.
Ok thanks for the qucik reply.
I tried a variation of this by adding a column in my table and got a Syntax error:
Adding on to my ask,
I want to see data in a range of dates.
Like:
Ok I ended using this instead:
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
I didn't know it existed and it works great!
I appreciate your assistance before.
Hey,
I created a calcualted column so that I could use this field as a filter for a card visual I had that showed the number within the past 2 weeks. This may or may not work for your situation; it works for mine as the data is always a day out of date and I look at the most recent period as at date data refreshed.
Yes sorry I just figured that part out.
But this just gives me 14 days ago totals and not 0-14.
I need a range.