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
TheBlackCrown
New Member

Help Requested: How to get N/A to appear in a column full of numbers

I'm working on building a report for a client and I need "N/A" to appear in blank columns. I tried putting a 0 there but my client was not a fan. I cannot seem to figure this out, "N/A" is text and the columns I have are full of mostly whole numbers. Is there anyway to do this?

 

I cannot change the numbers to text, there is some conditional formatting/ a heatmap for the numbers. Changing this to text ruins the heatmap.

5 REPLIES 5
TheBlackCrown
New Member

I'll give it a go, thank you friend.

@TheBlackCrown  No worries at all! More than happy to help


Appreciate your Kudos!

Please accept the solution if it answers your question 🙂

 

Easy Power BI Tutorials

Unleash the full potential of Power BI with Help Xel

Visit HelpXel
2.png


SidTrengove
Advocate III
Advocate III

Hey @TheBlackCrown !

This seems to work for me: would you want to try something similar to this?

SidTrengove_0-1675276332685.png

SidTrengove_1-1675276342745.png

 


Appreciate your Kudos!

Please accept the solution if it answers your question 🙂

 

Easy Power BI Tutorials

Unleash the full potential of Power BI with Help Xel

Visit HelpXel
2.png


It works! But how do I get N/A to appear in the column I'm working on rather than in its own column. Currently it recreated the column I'm working on.

Hey @TheBlackCrown  

 

Would you be abe to give me an example with an image. Stuggling to get my head around this one 😊

 

I'll try my best once you post a copy 👨‍🏭


Appreciate your Kudos!

Please accept the solution if it answers your question 🙂

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.