This article explains that how to get different visuals from our pre-built visuals in Power BI. I have used these visuals on my project so I thought this would help other when you have same kind of scenarios.
My business user was using excel for their reporting and recently moved to Power BI. They were looking for a visual which is supported only in excel but they want to get in in Power BI.
As we know, we do not have any pre-built visual as like above, but we can get by combining 2 different visuals with overlap. Let me share how I achieved this visual.
Let us take a sample data for this visual. I am using financial sample data and these visuals are using Count as an aggregation type as I want to show the result with small number.
First build a clustered column chart as like below using following columns Segment, Country & Count of Records.
Next drag and drop another clustered column chart and use the following columns Segment & Count of Records. Note – Do not use Country on legend.
Now, we need overlap on the same position and set the 2nd visual to back which means the 1st chart with country will be in front position.
Select both the visual and group them. Finally, you will see the result like below.
Visual 2 – Custom Donut & Pie Charts.
Same as previous approach, we are going to get below visuals.
I have used 3 charts and grouped them to make it as single chart.
Place them all with some space and group it. Like these 2 visuals, you can play with other visuals and get a new visual. Share your comment below.
Download the PBIX from here.