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
Anonymous
Not applicable

Customize the Blank message to some text

I am comparing two values in power BI and sometimes it does not match and it is showing message as Blank,,I want to customize the message to "No Data Available"..Please suggest the best and easy way.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

 

You can go to visual level filter and please uncheck the blank values(If any),

Better to share the pbix file (Please change the confidential data) or screenshot with proper requirements.

 

Thanks,
Amit

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi,

You can write your logic in using IF() in DAX.

Create a calculated column like this-

Column = IF(CustomerT[State]="NY",CustomerT[State],"No Data Available")
 
Thanks,
Amit
Anonymous
Not applicable

Thanks Amit..

 

I have two visualization..one for incident by state and other is change by state. These visualization interact with each other.. when there is no change related to incident... then change pie chart greys out and reads "Blank" I want to customize it to "No Data Available" Please help

Anonymous
Not applicable

Hi @Anonymous ,

 

You can go to visual level filter and please uncheck the blank values(If any),

Better to share the pbix file (Please change the confidential data) or screenshot with proper requirements.

 

Thanks,
Amit

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.

Top Solution Authors
Top Kudoed Authors