Forum Discussion
Data Type for Data Label Changes Once Dashboard Published to Server
- 1 year ago
HI acollins1984 ,
Depending upon whom you ask, this is either a "feature" or a "bug" that happens now and then. To make sure that
the Service and the Desktop match, make sure it is formatted correctly. In Desktop, select the column, then , in the ribbon make sure that the format is set to Percentage and not to a number or decimal. AND, make sure that the number of space you want for the Percentage is set.If it is a measure or DAX column, make sure that you have the formatting in the statement set to the percentage (somethign like "0,00%").
Or, you could even look at the Data Label in the Format Pane and make sure the value is set to percentage as well.
Then, republish and take a look. - Anonymous1 year ago
Hi acollins1984
Thanks for reaching out for Microsoft Fabric community.Power BI sometimes loses formatting on visuals especially card visuals when the data type is not explicitly set as a percentage. The measure returns a decimal (like 0.66) but formatting is applied only in the visual (not in the DAX) or if locale/regional settings in Power BI Service differ from your Desktop.
Format in the DAX measure itself, instead of relying only on the visual to show percentages, hardcode the formatting inside your DAX measure.
If your original measure is like - Percent Complete = DIVIDE([Completed], [Total])
Update it to - Percent Complete Formatted = FORMAT(DIVIDE([Completed], [Total]), "0%")Then use Percent Complete Formatted in your card.Once cross Check that the Data Type is set to Text, not Decimal
Since you're now using FORMAT, this becomes a text, so, Go to Model view → Select the new measure, make sure it says Data type = Text
This ensures Power BI doesn't reformat the result.
Clear the visual formatting, sometimes the card visual holds on to old settings, try to delete and re-add the card visual (if possible), or reset the Data label display units to "None" and Turn off “Value Decimal Places” to avoid auto-rounding.
Publish Again and Verify
After you've implemented the formatted DAX and verified on Desktop and Save the .pbix and publish. Then Check in Power BI Service to confirm the formatting is now respected.
Still needs any debug, If you want to avoid using FORMAT() (e.g., to keep sorting or tooltips functional), another route is once ensure the Data type of the measure is set to Decimal Number and then in the Model view, explicitly set the Format as Percentage, and apply 2 decimal places.
This avoids text conversion but relies more on visual settings being respected.
If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team.
Hi acollins1984
Just checking in to see if the solution we shared helped resolve your issue with the card visual formatting in Power BI.
To recap, we discussed formatting the measure directly using FORMAT() or ensuring the data type and format settings are correctly applied, both in DAX and the model, along with a few cleanup steps in the visual itself.
If you had a chance to try this out, could you please confirm if it worked for you?
If the issue’s resolved, feel free to mark it as the accepted solution, it helps others in the community who might be facing the same challenge.
And if you're still running into trouble, just let us know, we’re here to help!
Thanks again for being part of the Microsoft Fabric Community.
Best regards,
Akhil