Clustered Stacked Column Chart has same top

[Anonymous]

Hi,

Can anyone help me?

I have a Clustered Stacked Column Chart consist of 2 fields: cost and revenue. But the revenue data from one field has same top in all months. The same value is the total of revenue across the months. Both from difference fields or online link data (Postgre SQL). I already created relationship manually among both. How to resolve this issue

[v-piga-msft]

Hi @Anonymous ,

Is the Revenue column the total valur for all the month in your data sample?

If it is convenient, could you share your data sample so that I could have a copy and test.

Best Regards,

Cherry

[Anonymous]

No. The revenue of each month should show its value, not a sum.

3 months ago I got similar issue for Clustered Stacked Column when the revenue from Posgre SQL and the cost from Ms Excel. After I changed the data type of cost in Power BI that came from Ms Excel the issue has been resolved.

But because the Ms Excel  data is not real time I changed both from Postgre SQl of two fields or different field.

[Anonymous · Accepted solution]

I got a solution from this : https://community.powerbi.com/t5/Desktop/Charts-with-multiple-tables/m-p/493316#M229916

[v-piga-msft]

Hi @Anonymous ，

It's glad that you have solved the problem.

Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry