Need a customed bar chart

[ChainsawMan]

Hi All,

I need a bar chart like a multi row card. Can I achieve this effect?

Thanks in advance!

[Ritaf1983]

Hi @ChainsawMan .
By using conditional formatting in a table and grouping with a text box, you can create a chart with a "filling" effect similar to yours.
Attached is a picture of the result.

The file I used to follow my steps can be downloaded from this link:
Link to the PBIX 

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

[ChainsawMan]

Hi Ritaf1983,

I want to place the x-axis on top of the bar chart, can I do it?

[v-yueyunzh-msft]

Hi , @ChainsawMan

Based on your sample screenshot and description provided, I think you want to achieve a bar chart with the total row displayed above, right?

If so, you may try my method to achieve the similiar output as yours in the Power BI:

This is my test data table:

You can first create a calculated table like this:

Table with total column =
var _total=SUMX(ALL('Table'),'Table'[Value])
var _row=ROW("Year","Total","Value",_total)
return
UNION('Table',_row)

Then you can try to create a "Clustered bar chart" and place the fields within the calculated table like this:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[ChainsawMan]

Hi StarLight Aniya,

I want to place the x-axis on top of the bar chart, can I do it? Currently the x-axis is on the left side of bar.

[v-yueyunzh-msft · Accepted solution]

Hi , @ChainsawMan 

Thanks for your quick response!You want to place the x-axis on top of the bar chart.

I'm sorry, but I've been searching for a long time and haven't found a bar graph visual that puts the Y axis on top of the X axis.

For your need , you can try to use the Matrix as a workaround.

This is my test data:

Now we can put this in the Matrix:

Then we can give the "Values" a "Conditional formatting-Data bars".

Then we can get the visual like this:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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