Forum Discussion
line graph for multiple items
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 ::
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 ::