Forum Discussion
PowerBI visual creation
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
Anonymous , 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/QgI0vIGIOOkTableau Vs Power BI - Bar Visual - https://www.youtube.com/watch?v=tAmg00Wf_cw&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54
Hi Anonymous
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.
4 Replies
Hi Anonymous
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.Anonymous , 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/QgI0vIGIOOkTableau Vs Power BI - Bar Visual - https://www.youtube.com/watch?v=tAmg00Wf_cw&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54