cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Candi721 Frequent Visitor
Frequent Visitor

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

Accepted Solutions

Re: Customize the Blank message to some text

Hi @Candi721 ,

 

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

3 REPLIES 3

Re: Customize the Blank message to some text

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
Highlighted
Candi721 Frequent Visitor
Frequent Visitor

Re: Customize the Blank message to some text

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

Re: Customize the Blank message to some text

Hi @Candi721 ,

 

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