Skip to Content
Former Member
Oct 31, 2009 at 04:04 AM

How to refresh Chart



I have created a Dashboard with First Quarterly Sales data and then Monthly when we click on any Quarter in Quarterly Sales Chart,accouding to that Selected Quarter,data in Monthly chart should come.I am taking Data from SAP BI query , so i have one query for Quarterly data and another for Monthly.

In Quartly Sales data i have done refreshing as "Refresh on Load", and in monthly i have done as value change(when selected value change in cell),it is working fine when we click on any quarter,but on loading time monthly sales chart remains empty,its not showing any data.If i do "refresh on Load" in this chart also then its showing error regarding Prompt value.

So my question is how to handle this condition,that it will work fine in both condition, on loading as wellas on click on any quarter?