PowerBI visual creation

[Chloe_gsq]

Hi everyone, 

Thanks a lot in advance for trying to help me with this. 

So basically, I'm trying to transition from Tableau software to PowerBI, but have a hard time duplicating the following chart on PowerBI. The main difficulty is to recreate the stacked bar chart with a linear split by country and channels.   I have tried a matrix with data bars as cell elements but our options are limited in terms of visual options. So if you have any idea of how to recreate this visual on PowerBI it would be amazing! 

Thank you very much in advance for any input, even if the answer is that it's not possible at all! 

Have a nice day, 

Chloe

[amitchandak · Accepted solution]

@Chloe_gsq , The best you can get is like this, Concatenate Label - off, Reduce y-axis font . Sort on Axis. In this case I sorted on State, year

Check for steps- When I recorded this video it was not supported horizontal Stacked bar, it is supported now

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

Tableau Vs Power BI - Bar Visual - https://www.youtube.com/watch?v=tAmg00Wf_cw&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54

[dk_dk · Accepted solution]

Hi @Chloe_gsq 

You would need to add both the country and year columns to the Y axis of the bar chart, like so:

and then drill down on the visual to the year level using the forked arrow button 

Then in the visual settings you can configure horizontal gridlines.

However, for the default bar chart visual I was not able to get the exact same look. For instance, I cannot get the gridlines to go "in between the bars", only separating the axis by country. And I cannot rotate the text on the axis either. These are limitations of the default power bi bar chart visual. You may try using a 3rd party visual from the marketplace to see if it has the formatting controls you desire.

[Chloe_gsq]

Thank you very much for taking the time to help, it all worked out! 

[amitchandak · Accepted solution]

@Chloe_gsq , The best you can get is like this, Concatenate Label - off, Reduce y-axis font . Sort on Axis. In this case I sorted on State, year

Check for steps- When I recorded this video it was not supported horizontal Stacked bar, it is supported now

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

Tableau Vs Power BI - Bar Visual - https://www.youtube.com/watch?v=tAmg00Wf_cw&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54

[Chloe_gsq]

thank you very much for taking the time to help, it all worked out!