Forum Discussion

martijnth's avatar
martijnth
Helper II
6 years ago

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...
Need Help
Show and Tell
Tips and Tricks
martijnth's avatar
martijnth
Helper II
6 years ago

Dear Giotto, thx for taking the time to support me!

 

Funny you mention, because the same happens here, when ever I publish all in one matrix works. However in then separate Cards it is not. 

 

This is code used in the cards:

 
Min.SinceLastGT = IF(
(DATEDIFF(MAX(TBM_PRODUCTION_DATA[ProducedOn]),now(),MINUTE)<4),
"Last GT within 2 min.",CONCATENATE(CONCATENATE("Last GT ",
DATEDIFF(MAX(TBM_PRODUCTION_DATA[ProducedOn]),now(),MINUTE))," Min. ago")
)
 
Formatting happens with(deliberately split measures for all machines, otherwise even in desktop not working):
 
Last GT tbm1 = CALCULATE
(DATEDIFF(MAX(TBM_PRODUCTION_DATA[ProducedOn]),now(),MINUTE),
Filter(TBM_PRODUCTION_DATA,TBM_PRODUCTION_DATA[EquipmentID]="TBM 1"))
 
in: 
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

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

 

  • martijnth's avatar
    martijnth
    Helper II
    6 years ago

    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

    • v-gizhi-msft's avatar
      v-gizhi-msft
      Community Support
      6 years ago

      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