Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
I got a solution from this : https://community.powerbi.com/t5/Desktop/Charts-with-multiple-tables/m-p/493316#M229916
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
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.
I got a solution from this : https://community.powerbi.com/t5/Desktop/Charts-with-multiple-tables/m-p/493316#M229916
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |