Filter problem

[HAMZA_07]

I have this data ...

When I put this data in LINE CHART this is the result ....

Now I will apply a filter to it

What I wanted was for it to give me audcad "Average %" in line..... and audcad "Average 5 years %" in another line

But what happened when applying the filter was collecting "Average %" and "Average 5 years %" and gave them in one line.

How do I solve this problem

[Ashish_Mathur]

Share the download link of the PBI file.

[sospsbrasil]

Sorry i posted on the wrong topic

[Ashish_Mathur]

I do not see any semblence between the screenshots and your PBI file.  Even if i want to help, I cannot.  If possible, then ensure that the table and column names are in English.

[Ashish_Mathur]

Hi,

Share some simple dummy data to work with.  share only as much data as is required to iluustrate the problem - so do not share 20 tables (that will only cause confusion). 

[HAMZA_07]

Sorry I'm new to the community....I made a sample here ...

Now I will apply a filter to it

What happened is.. he combined Average "5 years %" with "Average %" and gave me the result in one line... I don't want him to combine them, I want him to give me both Averages in two lines