Forum Discussion
Relationships cardinality
Thanks for this, I'm sure that this works but I am still unable to undersatnd how to do it thats just my weakness with power bi, i will give up on trying to do this but will accept that this is probably the solution.
In your S&OP table create a fake date column (for example first day of the month). Then join the tables via the date.
Hi, i have done this and i can bring in the S&OP but its the same figure for each and every account ID, it does not change as it should?
Make sure to use the date from the calendar table in the x axis.
I have made the change and the chart now looks as below and still does not change when another customer is selected as shown below.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Below is what i am trying to replicate with some sample data below.
ALL SITE
SITE_ID ACCOUNT_ID Customer Name Date SQM LOC 2000099 ABCDEF 01/04/2024 24419 LOC 2000099 ABCDEF 15/04/2024 5814 BEL 700373 HIJJJJ 25/04/2024 25256 BEL 700373 KNNNN 30/04/2024 31524 BUR 1010566 XXXXXX 10/04/2024 27054 BUR 1010566 XXXXXX 18/04/2024 3251 FEA 101021 ZZZZZZ 06/04/2024 15362 S&OP ACCOUNT_ID Month Name SQM SITE_ID 2128 April 825000 LIV 200976 April 35000 FEA 2775 April 26486 LIV 600146 April 4783 BUR 2002403 April 25200 LOC 600079 April 35000 BUR 600139 April 400000 BUR CALENDER Date Year Month Month Name ######## 2024 4 April ######## 2024 4 April ######## 2024 4 April ######## 2024 4 April