Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good Afternoon,
Is there an easy way using the filters pane to filter visuals on or before today's date?
I can't seem to see this as an option which seems a bit odd unless I'm missing it!
Thanks
Solved! Go to Solution.
If you have a calendar table, you can create an offset column which returns -1 if it's before today's date or 0 otherwise. Then, you can use filter pane to filter by <0 values
Offset = IF('Calendar'[Dates]<=TODAY(),-1,0)
Hi,
You could created a field in power query that flags all dates from today and use that on in the filter pane:
Power query column: if [Date] >= Date.From(DateTime.LocalNow()) then 1 else 0
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
You could created a field in power query that flags all dates from today and use that on in the filter pane:
Power query column: if [Date] >= Date.From(DateTime.LocalNow()) then 1 else 0
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
If you have a calendar table, you can create an offset column which returns -1 if it's before today's date or 0 otherwise. Then, you can use filter pane to filter by <0 values
Offset = IF('Calendar'[Dates]<=TODAY(),-1,0)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |