Customize the Blank message to some text

[Anonymous]

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.

[Anonymous]

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]

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 · Accepted solution]

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