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

     

     

     

     

     

     

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
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

    I tried this and after some editting I was able to get the Line Graph and Create the Relationship! Thank you very much all.