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
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

After my test, it works well on my Power BI Service.

Here is my test table and measure:

Measure = IF(SELECTEDVALUE('Table'[Time])<=2,"Last GT within 2 min","Last GT over 2 min")

Create a color measure, then set its conditional format and choose a table visual:

Color = IF([Measure]="Last GT within 2 min","#FF0000","#00FF00")

The result shows:

After publishing to Power BI Service, it shows well:

So, for your problem, please share your conditional format setting with me by screenshot.

And please tell me the visual you used for me to find the solution as soon as possible.

 

Best Regards,

Giotto Zhi

 

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