Forum Discussion
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, so if there's an answer already there, apologies, and maybe someone could point me to it!?
I work for a health charity and we want to map numbers of people with a condition, over time. Ideally, we'd like a multi-line trend graph, with each condition mapped across multiple years, and if possible a slicer to select by condition (i.e. to show selected graph lines).
How do I go about this? Or perhaps it's not the best way to go. Data is organised, in excel, as follows
| year 1 | year 2 | year 3 | year 4 | year 5 | year 6 | year 7 | |
| condition 1 | data | data | data | data | data | data | data |
| condition 2 | data | data | data | data | data | data | data |
| condition 3 | data | data | data | data | data | data | data |
| condition 4 | data | data | data | data | data | data | data |
| condition 5 | data | data | data | data | data | data | data |
| condition 6 | data | data | data | data | data | data | data |
many thanks
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 ::
3 Replies
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.
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
