Forum Discussion
Helper IIJoin and model the data with different granularities
Hi kobkabnaja
Your question has soved at another post, so you can consider to close this post, and you can offer solution in this post so that more user can refer to.
Best Regards!
Yolo Zhu
Solution Sagehello kobkabnaja
when you reference two columns from diffrent tables in visual or measure then you can to create relationship between those tables in model relationship tab in powerbi, otherwise your visual will show same amount on each bar or columnof that chart, when you create relationship between two tables that table the those two tables will act as one whole table, join the tables based on common feilds column(we call is primary key and secondary key) it could be your transaction id or the order id(you have to check it).
create two measures for YTD expenditure and yearly budget and drag and drop those two measures in value feils of the bar or column chart , you will see column or bar for both categories.
let me know if you have other doubts.
learn more about powerbi:
https://analyticpulse.blogspot.com/
PowerBI Basics
Support on Youtube:
https://www.youtube.com/@AnalyticPulse
https://www.youtube.com/@TheRisingCitizen