Forum Discussion
conditional formatting in Service Mode
Dear Reader, report with conditional formatting is working fine in Desktop mode. However in Service it is not working properly, see below, if measure is 5 minutes or more background will be red, if...
Hi,
After my much test, i seem to find the key point of problem, it is due to different calculation of current time by time zone on Power BI Desktop and Power BI Service.
When you refresh dataset on Power BI Service, it displays the different time:
So in this case, you should not use NOW() dax expression but give a sepcific time you want.
Best Regards,
Giotto Zhi
Hi Giotto,
thanks for your support, not sure how to capture the current time with using something like NOW() or UTCNOW(). How would you do this?
reg martijn
Hi,
Now() is used to show your computer time on Power BI Desktop and UTC time on Power BI Service.
And UTCNow() is used to show UTC time both on Power BI Desktop and Service.
Best Regards,
Giotto Zhi