Hi there! I have a column that has both text and numbers.
I need to format the numbers within the column to include a comma, but since the column also has text, it's not allowing me to apply a format to the cells that have numbers featured since the entire column has been data typed as text due to the "not available" text.
Thanks so much!
Consider the following measure/column:
FormattedPop =
IF(Table[Population NA] = "Not Available","Not Available",FORMAT(Table[Population NA],"General Number")) You for the "General Number" part, you can tweak it to your requirements.
Take a look here for format options: https://learn.microsoft.com/en-us/dax/format-function-dax
Proud to be a Super User! |  |
Consider the following measure/column:
FormattedPop =
IF(Table[Population NA] = "Not Available","Not Available",FORMAT(Table[Population NA],"General Number")) You for the "General Number" part, you can tweak it to your requirements.
Take a look here for format options: https://learn.microsoft.com/en-us/dax/format-function-dax
Proud to be a Super User! | |
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
FabCon &SQLCon Highlights
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
