Forum Discussion
Measure error to avoid blank pie chart "The function SUM cannot with values of type String"
I am creating a dashboard with various different pie charts that will be refreshed periodically throughout the year. I have one pie chart that currently has no data available and is therefore appeari...
The card now says "BLANK" instead of "No Data Available" and did not disppear when data became available unfortnuately
Hi jessmc64 ,
Thank you for your patience!
Since the measure is returning blank,try using the below query
Measure =
VAR PlannedSpending = SUM('B-Base Planned'[Planned])
RETURN IF(NOT ISBLANK(PlannedSpending), BLANK(), "No Data Available")
Also,check if the card visual have a "Show blank as" option set to display text (like "BLANK").
I hope this helps.If so,consider accepting it as solution.