Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |