line graph for multiple items

[radmin]

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

[radmin]

Thanks for the speedy reply, looks straightforward, I'll give that a go. 

[Anonymous]

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

[collinq · Accepted solution]

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 ::