Forum Discussion
Wrong number formatting data label when highlighted
It sounds reasonable, but still doesn't work..
Luckily this was not in a Production file, but just connected to a test environment and in the production environment it worked without any workarounds..
Hi vipett ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you GeraldGEmerick ChielFaber rohit1991 for the prompt response.
The percentage formatting disappears during highlighting because Power BI creates an internal “highlighted value” that loses the measure’s formatting metadata in your PBIX.This is why the problem does not happen in a new file.Keep your original numeric measure, but create a display-only wrapper measure for data labels:
On-time % (orders) – Display =
VAR v = [On-time % (orders)]
RETURN FORMAT(v, "0.0%")
Then:
Use [On-time % (orders)] for the visual values.
Use On-time % (orders) – Display only in Data labels.
This forces Power BI to show the correct % formatting even when the visual is highlighted.
If formatting still breaks:
Your PBIX has corrupted formatting metadata - recreate the model in a new PBIX (this is why your test file works correctly).
It sounds reasonable, but still doesn't work..
Luckily this was not in a Production file, but just connected to a test environment and in the production environment it worked without any workarounds..