Possible to Duplicate this Tableau Chart in Power of BI?

[Anonymous]

A co-worked came to me and asked if we can reproduce this visual from Tableau in Power of BI.

Essentially, we have 3 different categories sharing the Y axis, but all map to the same group on the X axis.

Anyone have any ideas on how this can be done in Power of BI?

Thanks!
Thomas

[negi007]

@Anonymous Simplest way of doing it would be to have 3 bar charts on over each other like below

[Anonymous]

Thanks for the reply @negi007.

This is essentially what we've done. I created 3 seperate charts, turned the X axis labels off on the top 2 charts, and aligned them to the best of my ability. It sort of works, but it feels like a hack. Did you just cover the labels of the top 2 charts with the lower graphs? In other words, the X labels are behind the lower charts?

It's been a while since I used Tableau, but I remember there were some great tools for adding additional fields (i.e. more than 2) to an axis, as well as deciding what to do with them, once they were there.

Does Power of BI have anything like this?

Thanks,
T

[PaulDBrown · Accepted solution]

@Anonymous 

Following @negi007  suggestion, you can turn off the x-axis (titles and values) under the Format pane for each of the top 2 charts. 
You might also want to group all 3 charts once aligned (select all 3 using ctrl or by dragging the cursor PowerPoint style and then right-click + Group). You can also group them under the View / Selection.

You might also explore the custom visuals options for a possible visual which does all this automagically

[Anonymous]

Thanks for the replies everyone. I appreciate it. I'm a little dissapointed (in Power of BI's capabilities), but I learned a lot 🙂

Thomas

[PaulDBrown]

@Anonymous 

Did you get a chance to explore the customs visuals store? There are some visuals which might come close to what you are looking for. One Example: Column Chart With Small Multiples 

[negi007]

@Anonymous I have also used tableau and it was easy to create that sort of visual. But every tool has plus and minuses. 

In the first two charts I removed the axises. only showin in the last bottom chart. I think visually it gives similar looks. Also many a times we have to use these hacks to create great designs.