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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Option to FORMAT () values as numbers (not strings)

The FORMAT () function should be extremely flexible for conditionally formatting measures based on slicers and so on. But right now not even chart visuals agree with it. Please fix it? Pretty please?
Status: Needs Votes
Comments
DarrenDougill1
New Member

Why allow a user to create a measure and format as currency/percentage etc and give the output as text so you can't plot on a chart, which is the whole purpose of Power BI?


Please can this be done?

AndyJohnson
New Member

Either allow a specific number type to be included in the FORMAT() function or allow formats to be applied with an expression from a data driven field in the model within the measure formatting window. The format measure window currently only allows a static input, but ultimately setting a format here still allows measures to be plotted to charts.

ecrane
New Member

Still relevant. I could use this functionality for a current project!

fbcideas_migusr
New Member
Status changed to: Needs Votes