Forum Discussion
Values in Line Chart
Hello,
I have date & some index values which I would like to show in "LINE CHART" .
But when I add index values to values field it is summing up the values- I have tried dont summarize option in Modelling tab but still the same.
How can I show the values as it is in the line gragh???
5 Replies
- amitchandakSuper User
dia612 , No any value other than axis will be summarized.
Can you share sample data and sample output in table format?
- dia612Helper IV
Hello amitchandak,
Thank you for replying.
I have data simlar to this
I have to forecast future values based on these which i have done
Now i have to plot them in line chart by showing the values as it is and also differentiating the forecasted values like with dotted line or diff bg
something similar to this
Is there any sol in power bi for this???
- amitchandakSuper User
dia612 , if you have used power BI forecast it will show like this. If not. Have forecast value as separate measures. make sure they are null till actual is available. You will get a line in a different color, but you will not get an area.
https://towardsdatascience.com/forecasting-in-power-bi-4cc0b3568443