Problem with Line Chart and RANKX FUNCTION

[Giuseppe_Romeo]

Hi everyone, 
I have problems with the line chart chart and the RANKX function. Specifically, the task is to develop a line chart graph that allows me to view the monthly trend, of a specific year, of the sales value of topN Brands.
I have created a Slicer which allows me to choose the TopN value. The problem occurs when I choose topN = 2 because the lines in the graph are fragmented, so it identifies 2 brands from January to April and another 2 from April to December. How can I make sure that the lines are joined and not fragmented?

Thanks

[Anonymous]

Hi @Giuseppe_Romeo,

Any update on your requirement? If the above does not help, please share more detailed information to help us clarify your scenario and test:

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Giuseppe_Romeo,

If you mean the different data labels that be grouped by legend, they can't be linked with different data labels. (they are split by power bi analysis and aggregations features and grouped by current axes and legends)

Perhaps you can write a measure formula to instead the value fields to keeping the current data line to the next data label(similar to cumulative calculations) if other values have been filtered. Then these line graphs will be linked.
Regards,

Xiaoxin Sheng