Displaying multiple datasets in a chart

[DavidOChapman]

Hi,

I have a workbook of property investment timeseries - yields, stock etc. - and I have added this into PowerBI.

A dummy example of the data is below. In the real dataset, it covers most capital city submarkets for most countries across Europe.

I have set up filters to allow me to filter for stock or yield then the individual cities.

In the resulting line graph, rather than a line for each market, I am seeing just one line, not distinguishing between cities.

Is there a setting - a data type for instance - I should adjust to make graphs display a separate line?

Any help would be much appreciated.

DC

[v-yingjl]

Hi @DavidOChapman ,

Maybe you can put the Market Area into Legend field to show each market line:

Best Regards,

Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@DavidOChapman 

Once you click on the chart it will so visualization property. Which is not visible now.

Seem like as of now Date Hierarchy is used. You can right click on it visualization tab and change to date.

Then you can take the company or city as a legend and you will see multiple lines

[Greg_Deckler]

Can you post data as text? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[MFelix]

Adding to @Greg_Deckler ,

Also check How to provide sample data in the Power BI Forum (courtesy of @ImkeF).