need to display message when there is no data

[Herndon_powerbi]

Hi,

     I have a table visualization like below:

         I need to create a message "No Data" when there are no values for Maths and English. Please let me know how can I do it in Power BI.

Thanks in advance

[Anonymous · Accepted solution]

Hi  @Herndon_powerbi ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure_Math = IF(MAX('Table'[Maths])=BLANK() ,"No data",MAX('Table'[Maths]))

Measure_English = IF(MAX('Table'[English])=BLANK(),"No data",MAX('Table'[English]))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[kcsteele]

try using a measure intead of the columns directly, and use the DAX IF(ISBLANK(table[column]),"no data",table[column]))

[Herndon_powerbi]

You are almost correct except that I need to insert the count function also.

IF(ISBLANK(count(table[column])),"no data",table[column]))

[likhithar]

@Herndon_powerbi  If you consider aMaths and English Coulumns  as text data type,you can replace null with"No Data" using replace text in power query editor

[Herndon_powerbi]

The message should display as below:

[parry2k]

@Herndon_powerbi are these measures? if yes, share the DAX expression to provide the solution.

[Herndon_powerbi]

They are not measures, the column values are coming from a table