How do you avoid blanks in Power BI?
To hide the blank, you can make use of the broader conditional formatting options for the default Power BI visuals. You just have to set a conditional formatting rule that if the value is blank, the colour should be the same as the background.
How do I exclude blank values in DAX?
ALLNOBLANKROW DAX Function (Filter)
Returns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been applied.