Forum Discussion

Julier's avatar
Julier
Helper III
2 years ago
Solved

Relationships cardinality

Hello i am trying to link the two tables below by account id, but keep getting them message regarding cardinality and i am unable to find a link that works to allow me to build a combination chart sh...
Need Help
  • Julier's avatar
    Julier
    2 years ago

    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.

Julier's avatar
Julier
Helper III
2 years ago

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.

 

lbendlin's avatar
lbendlin
Super User
2 years ago

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

  • Julier's avatar
    Julier
    Helper III
    2 years ago

    Below is what i am trying to replicate with some sample data below.

     

     

    ALL SITE

    		    
    SITE_IDACCOUNT_IDCustomer NameDateSQM
    LOC2000099ABCDEF01/04/202424419
    LOC2000099ABCDEF15/04/20245814
    BEL700373HIJJJJ25/04/202425256
    BEL700373KNNNN30/04/202431524
    BUR1010566XXXXXX10/04/202427054
    BUR1010566XXXXXX18/04/20243251
    FEA101021ZZZZZZ06/04/202415362
         
         
    S&OP    
    ACCOUNT_IDMonth NameSQMSITE_ID 
    2128April825000LIV 
    200976April35000FEA 
    2775April26486LIV 
    600146April4783BUR 
    2002403April25200LOC 
    600079April35000BUR 
    600139April400000BUR 
         
    CALENDER   
    DateYearMonthMonth Name 
    ########20244April 
    ########20244April 
    ########20244April 
    ########20244April 
    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      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.

      • Julier's avatar
        Julier
        Helper III
        2 years ago

        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.