Forum Discussion
sonuojha1
Helper IV
5 years agoBar line graph with pattern filling for future data
Hello All,
I have requirement to visualize data on bar-line graph as below image.
I have following measures to visualize:
1. Sales data available for 2019, 2020.
2. Forcested sales for 2020
3. Budget
I would like to visualize the above measures as below screenshot.
- For future months instead of current year sales, it should show Forecasted sales with pattern filling.
- Budget as a line graph.
- When I select multiple year it should show current yr - previous yr data side by side.--> this has been done by changing sorting order.
Any help would be appreciated.
Regards,
Sonu
2 Replies
- v-robertq-msft
Community Support
Hi, sonuojha1
You change the color for data in future months, but I guess there’s no way to set pattern filling for a bar chart in Power BI. You can go to these links to vote for this idea which suggests adding a pattern fill bar:
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.