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.
have added the calendar but no luck, I have added a chart which shows SQM for each site by date but i needed to add the monthly S&OP for each site i have tried everything but no luck
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/1447523