Forum Discussion
Measure error to avoid blank pie chart "The function SUM cannot with values of type String"
Thank you so much for your help I'm so colse!!
The visual is showing up saying "No Data Available". Now all I need is for it to disappear when there is data. I tested this by updating my linked speadsheet with some numbers in the 'Planned Spending' rows. When I hit refresh my pie chart appeared, but the "No Data Available" card is still on top. How do I make it automatically go away when there is data?
Hi jessmc64 ,
Thank you d_m_LNK for the accurate response!
Thank you for your question! To ensure that the "No Data Available" message disappears automatically when data is present, you may use the following measure :
Measure = IF( ISBLANK(SUM('B-Base Planned'[Planned])), "No Data Available",BLANK() )
ion.
Thank you for being a valued member in Microsoft Fabric Community Forum!
If it did not resolve your query,As d_m_LNK suggested please raise new thread about stacking visuals.As measure is fixed ,please mark the solution as accepted.
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.This didn't work, nothing changed. I'm probably gonna give up on this.