Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Clustered Stacked Column Chart has same top

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

 

Need Help

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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.