Clustered Column Chart - Issue while creating with uncommon axis dimension.

[shabaan]

Hello Guys,

We are facing an issue in PowerBI Desktop.

Scenario:-

We have two column for rating of employees.

One column is Provisional Performance Rating and other is Final Performance Rating having values as 1, 2, 3,4,5.

The Provisional Performance Rating and other is Final Performance Rating is different for each employee.

We need to make a Clustered column chart for displaying count of employees i.e Provisional Performance Rating VS Final Performance Rating for each rating.

Since the chart needs to be displayed on a common axis on rating data, now the count for  either Provisional Performance Rating or Final Performance Rating is displayed correctly instead of  showing both of them correctly hence we are getting wrong data.

The sample final output would be similar as shown below:

So would really appreciate if we could get any idea or help?

Thanks in Advance.

Regards,

Shabaan

[v-shex-msft]

Hi @shabaan,

Please provide some sample data or pbix for testing.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng