Forum Discussion

niho's avatar
niho
Regular Visitor
1 year ago
Solved

KPI values black

Dear all, 

 

since last week the KPI status is only showing black values in Power BI online.

All KPI meausres are created in Visual Studio and should appear in green, yellow or red. 

It worked pretty well for the last years, all of the sudden the status shows only black value.

 

However, when I open the pbix-File in Power BI Desktop it works fine. 

 

Does anyone encountered a similar issue?

 

Picture shows part of matrx visualization in Power BI online and desktop:

 

       

 

Thanks!

  • niho's avatar
    niho
    1 year ago

    Hello JohnB_MUFC 

    could you solve this issue? 

    Did you contact Microsoft? 

    We still have back KPIs in all our Power BI online reports.

    Regards

    Niklas

14 Replies

  • freginier's avatar
    freginier
    Solution Sage

    Hey there!

     

    Here are a few solutions for you:

    - Check if the latest Power BI service update has affected KPI status colors.
    Try clearing the browser cache or testing in a different browser.

    - Verify that the KPI formatting is set in Power BI Desktop, then publish the report again.
    Ensure the conditional formatting rule for KPI colors is correctly applied under Field Formatting.

    -If the KPI measures were created in Visual Studio, ensure they are still compatible with the Power BI Online environment.
    Try recreating the KPI measure within Power BI Desktop rather than relying on an external calculation.

    - If possible, use a custom KPI visual or a simple matrix with conditional formatting to see if the problem persists.

     

    Hope this helps!

    😁😁

    • JohnB_MUFC's avatar
      JohnB_MUFC
      Frequent Visitor

       

      - Check if the latest Power BI service update has affected KPI status colors. Nothing documented, issue happened at a time without any Gateway updates.


      - Try clearing the browser cache or testing in a different browser. Not just a browser issue - issue is wot iOS and Android devices.

      - Verify that the KPI formatting is set in Power BI Desktop, then publish the report again. KPI icons are fine within the Power BI Desktop (latest version), issue only in the Service. 

      - Ensure the conditional formatting rule for KPI colors is correctly applied under Field Formatting. Standard KPIs, no conditional formatting.

      -If the KPI measures were created in Visual Studio, ensure they are still compatible with the Power BI Online environment. They are MS standard KPIs, not bespoke.
      Try recreating the KPI measure within Power BI Desktop rather than relying on an external calculation. KPI measure (actual and comparision) has been tested in Cube and Power BI Dataset.

      - If possible, use a custom KPI visual or a simple matrix with conditional formatting to see if the problem persists. Issue also can be seen not related to KPIs - the sorting arrow is also black in a standard Matrix table with black column headers (normal behavior is white).

      • niho's avatar
        niho
        Regular Visitor

        Hello JohnB_MUFC 

        could you solve this issue? 

        Did you contact Microsoft? 

        We still have back KPIs in all our Power BI online reports.

        Regards

        Niklas

  • JohnB_MUFC's avatar
    JohnB_MUFC
    Frequent Visitor

    Hello,

     

    Yes, we're also encountering the same problem since Friday 21st Feb - default Red/Yellow/Green Shapes and Road Sign KPIs created by either Visual Studio or Tabular Editor are all black.

     

    We have also noticed that it isn't just the KPI but even the white down / up sort arrow in a Matrix table (with black header) is also black - so it isn't just relating to KPIs I feel.

     

    Regards,

     

    John 

     

     

    • freginier's avatar
      freginier
      Solution Sage

      Hi niho, 

       

      Strange, I'm sorry I can't help further. 

       

      Zoe

  • v-sathmakuri's avatar
    v-sathmakuri
    Community Support

    Hi niho ,

     

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

     

    Thank you!!

  • v-sathmakuri's avatar
    v-sathmakuri
    Community Support

    Hi niho ,

     

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

     

    Thank you!!

  • v-sathmakuri's avatar
    v-sathmakuri
    Community Support

    Hi niho ,

     

    I hope this information provided is helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

     

    Thank you!!

    • niho's avatar
      niho
      Regular Visitor

      Hello, 

      at some point it just worked again, so none of the answers helped solving this issue. However this thread can be closed. 

      Thanks

       

      • v-sathmakuri's avatar
        v-sathmakuri
        Community Support

        Hi  niho , 

        Thank you for your response. Since the issue is now resolved, please mark your reply as "Accept as Solution" .

         

        Thank you!!