Highlighting forecasted income

[guruprem]

Hi,

I visualized below chart. Last 2 months data is not actual ,it is forecasted data. I thought of wrapping a box around that 2 months and highlight as forecast. but when user select a signle month box is adjusting as per section but this box is appearing awkawardly irrelevant.Please suggest if there is any better way to differentiate actual and forecast information.

[MK_QSL]

You can show them by different color. Provide sample data ,would work on this for you.

[guruprem]

Sample data is here

INCOME	Month
775980.4	1/1/2015
1143367	2/1/2015
440096.1	3/1/2015
702325.7	4/1/2015
483749	5/1/2015
584405	6/1/2015

[MK_QSL · Accepted solution]

Where is cost?

How to identify that May and June data are Forecast data?

I mean is there any flag or field or criteria to define Forecast and actual data?

[guruprem]

It is a good idea to have flag, Thanks for that As of now last two months are foretasted so, I will create a flag in Data model and use a little light color to showcase forecast. Thanks

[buzzy996]

are u like this way?

[guruprem]

Thanks bro awesome I liked it and I will use this idea

[buzzy996]

np