Forum Discussion
Filter problem
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
5 Replies
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).
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
Share the download link of the PBI file.
Sorry i posted on the wrong topic
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.
