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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mwmchugh215
Frequent Visitor

Data Labels in a Column Chart

I have a column chart that uses a parameter slicer to change the Y axis values between three separate views. Is there a way to add logic in the measures within the parameter to automatically format the values? I'd like the data labels and total labels in the graph to display in millions for two of the views and thousands for the third, but using the auto setting on the labels formats in billions for the first two. If I set the labels to display in a specific format it applies to all 3 views, for example setting to millions will also apply to the third view which will just display "0.0m" for all columns since those values are in thousands.

 

Is this possible to have measures ignore the auto formatting and automically apply a set value format?

2 REPLIES 2
mwmchugh215
Frequent Visitor

@RMDNA I don't see that feature on my Power BI desktop and I'm on the latest version. It also looks like that feature is for changing the format of the number (currency, whole number, etc)... I'm looking to automatically set it so the data labels on the chart are always in millions or thousands depending on the measure that I'm displaying

RMDNA
Solution Sage
Solution Sage

Hi @mwmchugh215 - take a look at the brand new Dynamic Format Strings for Measures feature that was released this month. I believe it might be able to solve your issue.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.