Not able to create the stacked column chart!!!!

[Kharabela]

Hi Experts,

Following are the points to be considersed.

I have 2 tables with the following fields.

1. IPD: Subdept, ipd_revenue

2. OPD: dept, opd_revenue

Where subdept and dept are same meaning. 

we need a chart as the picture.

Many thanks in advance.

Regards,

KP

[v-haibl-msft]

@Kharabela

You can add a custom column for each table in Query Editor as below.

Close and apply Query Editor, create relationship and create a calculated column as below.

Then create three visuals like below. For details, please refer to attached PBIX file.

Best Regards,

Herbert

[Kharabela]

Sorry for replying so late. Thanks a ton mate. The concern is the dept/subdept are not same naming convention and it has populated several times. What you send thats three different charts, but mine needs to be only one.

1. Is there any provision or not?

2. Is there any provisuion to create temporary parimy keys?

Regards,

KP

[v-haibl-msft · Accepted solution]

@Kharabela

There is no such chart can meet your requirement with only one visual. We can only use multiple charts to show the result.

You can use Text Box (enable white background) to override the extra parts.

Best Regards,
Herbert

[Kharabela]

@Herbert

Thanks a ton boss.

Regards.

Kharabela