Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line chart from 3 tables

Hi, I have 3 tables as below: ManufTable: ManufId ManufName 1 ManufA 2 ManufB 3 ManufC   MonthTable: MonthId MonthShortName MothFullName 1 Jan-19 January 2 Feb-...
Need Help
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    Make the following relationships:

    • Manuf - Sales -> one to many
    • Month - Sales -> one to many

    Then create a line chart with the following format:

    • Axis - MonthShortName
    • Legend - ManufName
    • Values - Sales

    You can then use a slicer to filter the months.

     

    Check PBIX file attach.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
6 years ago

Hi Anonymous ,

 

Make the following relationships:

  • Manuf - Sales -> one to many
  • Month - Sales -> one to many

Then create a line chart with the following format:

  • Axis - MonthShortName
  • Legend - ManufName
  • Values - Sales

You can then use a slicer to filter the months.

 

Check PBIX file attach.

 

Regards,

MFelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Perfect! Thank you so much. Just as I wanted it to be :)