Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |