How to store top n brands as a measure so that it can be used in line chart?

[Shivakumar_S_D]

I am creating a Top N Ranking report using DAX, the user can select the number of top n brands to be displayed and a table visual gets altered according to the number selected. Now on the other page, I need the same brands to be displayed as a trendline chart so they can see all the historical data regarding those brands.

I used the same DAX measure to extract the top n brands but that measure cannot be used in the line chart as a legend.

Also tried to create a dynamic table which can store these brands and changes according to the filter selection, but found out that it is not possible in power bi to create a dynamic table in power bi.

Thanks in advance

[Greg_Deckler]

@Shivakumar_S_D Yes, you are correct in all of this. Measures cannot return tables of data, only scalar values. I have harped on this for a long time that I wish Microsoft would allow measures to return tables. Also, yes, you cannot use measures as an x-axis, for that you need the disconnected table trick. But, not dynamic. How is the user selecting the number of top n brands to be displayed? If it is via a slicer or something, perhaps you can use Sync Slicers to ensure that the trendline chart is updated in coordination with the first page?

[Shivakumar_S_D]

@Greg_Deckler, Thank you for clarifying the doubt, I have already tried syncing the slicers, but that doesn't help since the first page tables are based on a measure and the line chart is based on a column from a different table