Can't display more lines in visual in Power BI

[Analitika]

Hi,

I would like to  ask how make that using one measure I could display lines in visual. Line and clustured column chart. I tried and see that need to create separate measure for each year, but how make one measure that will display lines we selected in date slicer years.

Link to Power BI file: example_visual.pbix - „Google“ diskas

[v-jianboli-msft]

Hi @Analitika ,

Yes, currently if you want to add multiple lines to the Line and clustered column chart, you have to create a measure for each line.

Best Regards,

Jianbo Li

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

[Analitika]

So if data has years like from 2010 until now, so 24 measures for example, will be created for each line? So ineffective.

[Anonymous]

Sadly this is the case yes.

[Analitika]

So no workaround?

[Anonymous]

Not to my knowledge besides for the 1 measure 1 line.

[Analitika]

Oh no. So visual will be overwhelmed.

[v-jianboli-msft]

Hi @Analitika ,

To my knowledge, the "lenged" column only affects the columns in a combo chart in power bi for now. 

An idea similar with what you expect has been submitted here, please vote it up and you can add comments.Hopes Power Bi will implement this in nearby future.

So for your requirement, there are two workaround for you refer to:

1. As you said, create different measure for each category and then drag them in Line values.

    If you want the number of measures to change dynamically based on your choices in the slicer, you can consider creating field          parameters to replace these measures

2. Exchange Line values and Column values, and then drag category into column series.

Best Regards,

Jianbo Li

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

[Analitika]

So as I understood correctly, Power BI doesn't that feature at this time, so I have to create each measure for each year, right?

[amitchandak]

@Analitika , You have used year as a legend in that case

[Analitika]

I have no idea how fix it.

[Analitika]

So what I have to change, fix? To get lines number as selected in slicer. Adding example, how I would expect to see visual.