Power BI Visual

[JorgeAbiad]

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

[amitchandak · Accepted solution]

@JorgeAbiad 

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/

[v-yingjl · Accepted solution]

Hi @JorgeAbiad ,

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:

1. https://www.youtube.com/watch?v=wr2vA3lGK8w
2. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
3. https://www.tutorialgateway.org/line-and-clustered-column-chart-in-power-bi/

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@JorgeAbiad 

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/

[JorgeAbiad]

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

[2019]

Highlight the graph then on the top right hand corner of the graph click on the three dots then scroll down to sort by and select month

[amitchandak]

@JorgeAbiad ,

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