Forum Discussion
Forecasting
Is there any way to display dynamically last three data points(forecast values ) with different colour other than previous colour points in line chart.
5 Replies
you can create a ew measure just for forecast and plot both on he chart, his will have the same visual effect, e.g.:
Regular = SUM('Table'[Val]) Forecast = CALCULATE([Regular],'Table'[Type]="Forecast")how do you determine the last 3 data points? is there a flag, or is it based on time?
Stachu Actually i need a line graph with functionality including the last 3 data points with different colours dynamically for given inputs.As of now am not concentrating on forecast.
For example,Year on X-axis and Sales on Y-axis likewise.
Hi SwapnaChippagi ,
You can simply use a visual level filter to achieve last 3 values you want to see. See visual level filter: https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter.
Regards,
Jimmy Tao
