Forum Discussion
Power BI Visual
Hello PBI experts,
I would just like to know if the visual below is attainable in Power BI dektop?
We will have 5 values to be plotted here. Is it possible to combine area chart with bar graphs?
Thanks
Comparison
JorgeAbiad
Anonymous
In the clustered bar line chart, you have line options like Shaded area and dots.
Use customize series under shape and change each line as per need
Refer
https://www.tutorialgateway.org/line-and-clustered-column-chart-in-power-bi/
Hi Anonymous ,
You can try to use 'Line and clustered column chart' visual to meet part of your requirement, just enable Shade area and change the Stroke width as 0 to hide the line in Shapes option.
For more information about this visual, you can refer:
- https://www.youtube.com/watch?v=wr2vA3lGK8w
- https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
- https://www.tutorialgateway.org/line-and-clustered-column-chart-in-power-bi/
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- amitchandak
Super User
Anonymous
In the clustered bar line chart, you have line options like Shaded area and dots.
Use customize series under shape and change each line as per need
Refer
https://www.tutorialgateway.org/line-and-clustered-column-chart-in-power-bi/
Hello amitchandak ,
Thank you very much for this. However, I can't sort the values in X-axis. It should be like Jan, Feb, ...Dec. How do I achieve this?
Regards,
JorgeAbiad
- amitchandak
Anonymous ,
Assume your column is
Month = format([Date],"MMM")
Create a sort column and mark it as the sort column of the first one
MM =format([Date],"MM")
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
v-yingjlCommunity Support
Hi Anonymous ,
You can try to use 'Line and clustered column chart' visual to meet part of your requirement, just enable Shade area and change the Stroke width as 0 to hide the line in Shapes option.
For more information about this visual, you can refer:
- https://www.youtube.com/watch?v=wr2vA3lGK8w
- https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
- https://www.tutorialgateway.org/line-and-clustered-column-chart-in-power-bi/
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.