Questions on Visualizations

[vipinkmathews]

Hi

Recently I have checked Tableau for a new request. I could see some of the visuals created as below by just drag and drop the field to the Row & Column shelves.

Please let me know if the same can be achieved through Power BI. If so which visuals should I use to get the same appearance. 

Do I need to use any Group By for the second image in Power BI but tableau automatically maintains the hierarchy without any manual grouping by the user.

[stretcharm · Accepted solution]

Unfortunatly small multiples is currently an ommisiton in powerbi (with the exception of some custom visuals e.g. dot plot)

So your options are create several bar charts side by side (tricky to keep the axis the same) or use r visuals.

r visuals can do pretty much anything however you'll need r installing and a bit of r knowledge.

http://www.sthda.com/english/wiki/ggplot2-barplot-easy-bar-graphs-in-r-software-using-ggplot2

Hierarchies are easy in powerbi for matrix or some charts. You can drop in fields in the correct order and it will create the hierachy for you.

https://docs.microsoft.com/en-us/power-bi/desktop-matrix-visual

You can also create a hierachy in the fields lists by dropping a field onto another. This can then be dropped in to the visuals.

https://www.youtube.com/watch?v=q8WDUAiTGeU

Phil