Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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.
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]
)
Thank you for your reply Owen, I found a way to format it, so did not try your solution. But thank you again 😊.
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
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?
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 61 | |
| 48 | |
| 35 | |
| 25 | |
| 23 |
| User | Count |
|---|---|
| 134 | |
| 110 | |
| 59 | |
| 39 | |
| 32 |