Forum Discussion
line graph for multiple items
- 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 ::
Thanks for the speedy reply, looks straightforward, I'll give that a go.
- Anonymous2 years agoNot applicable
Hi radmin ,
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Hope it helps.
Best Regards
Yilong Zhou