Forum Discussion
Helper Ineed to display message when there is no data
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
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
7 Replies
- parry2k
Super User
Herndon_powerbi are these measures? if yes, share the DAX expression to provide the solution.
Herndon_powerbiThey are not measures, the column values are coming from a table
likhitharHelper III
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:
- 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]))
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
