David Kacheol wrote:
I cannot share the data unfortunately because its not mine.
Potentially you could use action filters to achieve this, but I'm struggling to visualize what you are asking. I'd suggest creating a sample which replicates your scenario using the Superstore sample data. See Packaged workbooks: when, why, how
In this example, I'm would like to always have the 'product' selected for the map appear in the top 4 sales trends whether or not it actually is a top 4 product for the chosen state. I would then in theory have 4-5 lines in the graphic depending on the state. If you look at California, Cafe Mocha doesn't show up, however, I would like it to with the top 4 products as well.
IssueExample.twbx 235.9 KB