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.
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
Below 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 |
Add the date column:
Create the calendar and wire it in:
Calendar = ADDCOLUMNS(CALENDAR("2024-04-01",TODAY()),"Year",FORMAT([Date],"yyyy"),"Month",FORMAT([Date],"mmm"),"MNo",FORMAT([Date],"mm"))Then you can base your visuals x axis on the calendar.
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.