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...
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?
That sounds like a separate issue than the measure. It sounds like you are stacking two different visuals on top of one another? This might be a good post for a new thread maybe. If the measure is fixed can you mark the solution and post a new thread about stacking visuals when blank?