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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

New Slicer Power BI formatting value added as a label

Hello Community

 

I have the new slicer with average as a label in it. It is showing the average with multiple decimal points after comma. I tried even to force formatting it with a measure, but it did not work. Does any one has an idea of what I am doing wrong? Thank you for your support 😊. I just need to display one decimal place.

 

Screenshot 2024-09-04 151340.jpg

4 REPLIES 4
idkwhatimdoing
Advocate I
Advocate I

I just used your suggestion to simply reference the measure and it's all good. I just wanted to show "--" or "0" instead of blanks. I tried different itterations of dynamic formatting, which works fine if I'm using a card. So frustrating, because I thought it had something to do with my original measure. 

Measure Label = 
IF(
    ISBLANK(
        [Measure]),
        "--",
        [Measure]
)

 

Anonymous
Not applicable

Thank you for your reply Owen, I found a way to format it, so did not try your solution. But thank you again 😊.

Anonymous
Not applicable

Hi @Anonymous ,

Glad to hear that you have found a solution and thanks for OwenAuger's reply!

And @Anonymous , can you share us your solution and mark your answer as a solution so that more users facing the same problem can find a solution more quickly? Thank you very much!

Best Regards,
Dino Tao

OwenAuger
Super User
Super User

Hi @Anonymous 

Just looked at the options for Labels on the new slicer, and you're right, there aren't any visual-level number formatting options provided for Label fields. Also, number formats defined for the measure itself are not followed by the visual 😞

 

The only solution I can see right now would be to create a text measure such as:

Label Formatted =
FORMAT (
    [Existing Label Measure],
    "#,0.0"
)

and use this measure as the Label field instead.

 

Does this work for you?


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
LinkedIn

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.