Forum Discussion

vipett's avatar
vipett
Icon for Helper III rankHelper III
9 months ago
Solved

Wrong number formatting data label when highlighted

I have a simple graph with a measure "On time" which is formatted as %, normally it looks fine   But if I highlight a category or country or anything it loses its data formatting:  ...
Need Help
  • vipett's avatar
    vipett
    8 months ago

    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..

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
9 months ago

Hii vipett 

 

This happens because when a visual is highlighted, Power BI internally creates a second version of your measure (the “highlighted value”), and that temporary value does not keep the original formatting from the model. Since formatting is lost during highlight, the only fix is to explicitly format the measure using FORMAT() for the data label, like:

OnTime_Display =
FORMAT([On time], "0.0%")

Use this field only for labels/titles (not calculations). This forces the percent format even when highlighted and resolves the issue.

vipett's avatar
vipett
Icon for Helper III rankHelper III
9 months ago

Thanks, but even when I added that measure and put it in the Data labels tab as values, but I still get the same result