Chart options in BI
We have data in the report which runs monthwise for a year. Our requirement is if i have values for the months e.g APR,MAY,JUN etc., then I should get a chart as bar chart for APR,MAY and run chart for JUN - i.e., always the current month or the last month for which data is available should be in the run chart format and the previous months should be in the Bar format.
This should be displayed as default.
Your experts suggestion will be of much value.