Forum Discussion

Frequent Visitor

8 years ago

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.

Community Champion

8 years ago

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
Frequent Visitor
8 years ago
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
  Community Support
  8 years ago
  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
    Frequent Visitor
    8 years ago
    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) .