2 or more information in the horizontal axis.

[jujacobowiski]

Hi! Maybe it's a very stupid question, but I'd like to know if it's possible to have a chart like this:

Basically I'd like to reply this information in Power BI, but I'm not managing to have in the same chart 2 different y-axis. Is that possible?

Cheers.

[tringuyenminh92]

Hi @jujacobowiski,

I think yes, it's 100% Stacked bar chart: 

And you dont need to calculate percentage, your data is amount (number value)

[jujacobowiski]

I have this data here: 

But then when I try to plot Label 1 and Label 2 in like a 100% stacked bar chart, I just can put one value, like here:

I'm sure I'm doing something wrong, but if I replicate what you did and put some value in "axies", it doesn't show me what I wanna see. In my mind I should be able to put Label 1 and Label 2 in "values", so it would appear one below another like in the first pic I sent.

[jujacobowiski]

Ha!

I managed to do it, I had to invert my data, putting E1 - E2 - E3 - E4 like rows instead of collumns. Thank you very much!

[tringuyenminh92 · Accepted solution]

Hi @jujacobowiski,

you need a transformation with current data format to fit the legend and Axis of chart:

Create new table:

Transform Data = UNION( SUMMARIZE(Table1,Table1[Desempenho - Tema 10],Table1[Label 1],"Label","Forneceores") ,SUMMARIZE(Table1,Table1[Desempenho - Tema 10],Table1[Label 2],"Label","Volume medio (ton/ano)") )

If this works for you please accept it as solution and also like to give KUDOS.

Best regards
Tri Nguyen

[jujacobowiski]

Nice!

I did it but manually, good to know there is other way to do! Thank you very much!

[tringuyenminh92]

Hi @jujacobowiski,

i'm sorry about my curiousity, but could you please explain the meaning of Fornecedores, Volume ano and Tema Z ? Cause it's not english words so i could not understand behind meaning ^_^

[jujacobowiski]

Of course! haha

Fornecedores = suppliers; Volume = the total amount which was produced. I think it's also written volume in English. And tema is "Issue". Issue Z it's just a general name, could be A, B, C, 1, 2...

Thanks for the helping btw! It was very appreciate, especially because I just started in this Power BI life. :9