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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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