Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to create a Many to One relationship to create line graph

Hello,   I'm new to Power BI so i'm having trouble finding a solution to this. I have a table below:     I want to build a report with Line Graph on Power BI with the Quarters on the X-Axis,...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous

    You could try this way as below:

    Step1:

    In Edit Queries, select Supplier ID column then right-click ->Unpivot Other Columns

    or select 2017 Q1 - 2018 Q4 column Unpivot Columns

     

    Step2:

    Filter blank value and  click Close&Apply

     

    Step3:

    You could drag the field Attribute ino X-Axis and use this measure as Value

    Measure = CALCULATE(COUNTA(Table1[Value]))

    or add a year quarter fact table and create the relationship with data table by Attribute .

     

    Result:

     

    Best Regards,

    Lin

     

     

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Ninanguyen24,

 

In PowerQuery via Power BI Desktop, I duplicate the table I'd like to extract unique values from, then remove all cloumns not needed from the duplicated table, then remove duplicates from the cloumn I expect to turn into a unique vlaue table. I then reference through this table to create connection where needed.

 

I know it doesn't solve your whole problem, but it's an approach to isolate a table with unique vlaues.

 

PM