Forum Discussion

jessmc64's avatar
jessmc64
New Member
1 year ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

jessmc64's avatar
jessmc64
New Member
1 year ago

This didn't work, nothing changed. I'm probably gonna give up on this. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi jessmc64 ,
    Thank you for the patience.I'm sorry to hear that it didn’t work as expected. Please raise a new thread to get it resolved,we are happy to help you further.
    Since your first query was resolved, please consider accepting the initial helpful reply as the solution. This will help others who has similar issues.

    Thank you.