Forum Discussion

Jamme's avatar
Jamme
Regular Visitor
1 year ago
Solved

Dynamic Formatting Issue: Reference Value Not Applying on Report Server

Hey everyone,

I'm running into an issue with a new KPI card in Power BI. I'm using dynamic formatting for both the Callout and Reference values, and on Power BI Desktop (January 2025 version for Report Server) everything looks correct. However, when I publish it to Report Server, the Callout value still shows the right format, but the Reference value ignoring the dynamic format.

 

In PowerBI Desktop (January 2025)

Published in Report Server

 

Has anyone experienced this or found a solution? Any help is appreciated!

Dynamic Formatting
Report Server
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Jamme,
    Glad to know that you were able to find a workaround. As you mentioned you used normal KPI cards, can you please confirm if that solves your issue. If it solves then please mark the helpful reply as solution so that other community members can find the solution easily.

     

    Best Regards,

    Hammad.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,  Jamme 

    You can try checking your Report Server version to confirm that your Report Server version is compatible with Power BI Desktop (for example, the January 2025 release needs to correspond to a server that supports that version). If the versions don't match, upgrade Report Server or roll back the Power BI Desktop version.
    Prefer to format with field attributes and avoid relying on the FORMAT function: Use the formatting properties of the field (which is more stable) instead, and in the Power BI data model, locate the corresponding measure.
    Or force a refresh of the server cache to clear the cache on the Report Server. Go to the Report Server Management Portal.
    Navigate to Cache Refresh Schedules to create a new schedule to force a report cache to be refreshed. Revisit the report to check if the format is valid.
    You can also check locale consistency to ensure that the locale of Report Server is consistent with Power BI Desktop, and check the system locale format on the server. In Power BI Desktop, adjust the match through the File > options > Locale.

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Jamme's avatar
      Jamme
      Regular Visitor
      1 year ago

      Thanks for the reply and solution. I tried all the steps but it didn't work 😞 So rebuilt the whole report with just normal KPI cards instead of the new. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Jamme,
        Glad to know that you were able to find a workaround. As you mentioned you used normal KPI cards, can you please confirm if that solves your issue. If it solves then please mark the helpful reply as solution so that other community members can find the solution easily.

         

        Best Regards,

        Hammad.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Jamme,

    Thanks for reaching out to the Microsoft fabric community forum.

    It looks like you are facing issue while formatting your values in a visual. As Anonymous already responded to your query, please go through his response and check if it solves your issue.

     

    I would also take a moment to thank Anonymous, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Best Regards,
    Hammad.
    Community Support Team

     

    If this post helps then please mark it as a solution, so that other members find it more quickly.

    Thank you.