Forecasting

[SwapnaChippagi]

Is there any way to display dynamically  last three data points(forecast values ) with different colour other than previous colour points in line chart.

[Stachu]

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?

[SwapnaChippagi]

@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.

[v-yuta-msft]

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

[SwapnaChippagi]

@v-yuta-msftBut when I used Visual filters  ,its showing only 3 data points from bottom excluding the other points.I need a visual of all points in graph with highlighting last 3 points for dynamically changing input(slicers) .

[v-yuta-msft]

Hi SwapnaChippagi,

To achieve your requirement, you can take a consideration on Conditional Formatting.

Regards,

Jimmy Tao