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 less than 5 it should be green. You can that in service mode 2 are working, 8 are not working. In desktop all 10 are fine. Any ideas how to fix this?

reg martijn

Need Help
Show and Tell
Tips and Tricks

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    martijnth I would suggest creating a support ticket - support.powerbi.com or add this into the issues.powerbi.com forums as this type of thing happens periodically with different features and logging them in the above areas helps raise awareness.

  • 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