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)
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |