Forum Discussion

radmin's avatar
radmin
New Member
2 years ago
Solved

line graph for multiple items

Hi folks   all well?    New to PowerBI and I have a question. Before I start, I've searched forum for an answer, and not found it - no doubt (being new!) I'm not using the correct search terms, s...
  • collinq's avatar
    2 years ago

    Hey radmin ,

     

    To bring this data in you just hook to Excel.  I put in numbers for each of the years so that the lines would separate.  I also put in the SAME number for each year so my lines are all straight - the real world is never like that.  So, this is what the data looks like initially in a table view:

     

     

    Then, I created a slicer visual with the Condition field and that looks like this:

     

     

    Then, I changed the table visual to be the Line Chart:

     

    Now, when you select the slicer, you get the data for whichever condition you are lookng for.

     

    I would suggest that you get a Date Dimension and add it to the data and then you can drill down by year.  There are lots of Date Dimension tables out there i you do a search but here is one we provide (with some reasoning for it):

    Why Create a Date Table in Power BI? : :: Welcome To EPM Strategy ::