Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
90 | |
85 | |
65 | |
62 | |
58 |
User | Count |
---|---|
147 | |
113 | |
95 | |
81 | |
71 |