Data Modelling

[tsarun1992]

Dear All,

I've a question on data modelling again !! Let me share the scenario below,

Data 1

Data 2

In the above 2 charts, the data in X-axis and Y-axis remains the same. But the Legend & Filters differ.

Can I combine these two charts into one?

Like in X axis, I need the count of employee (Available per resource group) & also the count of employee (Backlog of Leads & Quotes) both in separate bars under each resource group.

Hope my question is clear !!

[tsarun1992]

Hi Amit,

Thanks for the response, I've already tried this option. But all what I need is not on the same column, but two different columns next to next.

[Anonymous · Accepted solution]

Hi @tsarun1992 ,

According to your statement, I think you want to combine two column charts as one. If you remove the column in legend, you can add two or more value columns in value field and the column names will be legend. However, now you want to keep the legend in chart1 and then you want to combine it with chart2. As far as I know , Power BI doesn't support us to do this.

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tsarun1992]

Hello Rico,

Yes you understood my need 🙂 Sure, I will post the New idea in the right place & let's see if there is any update regarding this in future. 

This comparison column chart will be of great help to compare data the same data with multiple parameters.

Kind Regards,

Arun T S

[amitchandak]

@tsarun1992 , there is custom visual, see if that can help

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview