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.
Hi all,
I have a calculated column to give a mark if a line is due on 'today' and I have that filter on in a table. So, on March first I uploaded the file to Service and I saw the jobs that were due on March first.
Today it is March third and I still see the jobs from March first. I refreshed the report and the dataset, but nothing is changing. When I open the Power BI file, it jumps to March 3th immediately.
Is it a bug, or am I doing something wrong? Thanks!
Solved! Go to Solution.
Since it's a calculated column it won't calculate again today's date until it's refreshed. It should work fine if you refresh the dataset and wait until it completes. In any case, you can set a measure to do this filter, such as:
INT ( 'Table'[Date] >= TODAY() )
You need to use INT in order to apply the filter (it would return 1 if true and 0 if false), you can use the previous measure as a visual filter. It won't let you add it to a filter box object. Hope this helps you anyhow.
Since it's a calculated column it won't calculate again today's date until it's refreshed. It should work fine if you refresh the dataset and wait until it completes. In any case, you can set a measure to do this filter, such as:
INT ( 'Table'[Date] >= TODAY() )
You need to use INT in order to apply the filter (it would return 1 if true and 0 if false), you can use the previous measure as a visual filter. It won't let you add it to a filter box object. Hope this helps you anyhow.
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.