Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
hucodaal
New Member

Reference labels formatting issues

I'm trying the new feature reference labels of the new card KPI visual. I encounter multiple issues:

 

1. Choosing the right display units

The values in the reference labels do not respond to the selected display unit

 

2. Choosing the right value decimal places

The values in the reference labels do not respond to the selected decimal places

 

3. Showing pct instead of decimal number

When showing a measure which is formatted as a percentage, the number shows as a decimal number instead of a percentage

I have tried various thing to mitigate this such as changing the data type and using the available formatting options of the measures themselves. 

11 REPLIES 11
TomT131
Frequent Visitor

Hi,

I am having issues with Reference label Detail. All looks fine in desktop, however when published to Service, the Detail measure drops off.
When try to re apply it in the Service, the whole visual produces an error.

Really like these new features but would be good to have them a bit more stable

Thanks!

I am also having the same issue.

Colibri
Frequent Visitor

same issue

pwolff86
Regular Visitor

Having the same issue as you.

 

In the meantime while Microsoft fixes this bug, you can wrap the reference label measure in a FORMAT function like this, which led to the correct auto formatting in terms of display units and decimal places in my case:

 

FORMAT (
        CALCULATE (
        [measureToBeFormatted]
    ), "#"
    )

Just noticed this, the formatting option is present inside the [Reference labels] setting as well! 

 

In the [Detail] or [Value] options of the [Rreference label], in [Display units] dropdown you can use the "Custom" option at the end to define the formatting required.

 

But wierd why the formatting is not automatically detected.

 

siddharthaR21_0-1701696510526.png

 

Excellent find.
However, the formating on some measures seems to be locked for me, even with the custom settings. It is a bit random, and still an issue.

SanderHovestad
New Member

And same here. There has been an updated PowerBI desktop application, but unfortunately that does not resolve the issue. I also have the same issue with the sample document that has been released, so maybe we just have to be a bit more patient?

Boegebjerg
Frequent Visitor

Same issue...

Franco
Frequent Visitor

Same issue!!!

cassidy
Power Participant
Power Participant

Having the #3 issue, Measures used on Detail labels that are % show was $0.

FredrikJ
Helper III
Helper III

Same issue here!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.