Create dynamic X asix

[BInewbie]

Hi All,

I am trying to create a dynamic X axis where by the user should be able to select the variable they want to see on the X axis, with the Y axis fixed to Sales, e.g. Sales by Country, Sales by Person, Sales by Store etc.

The data is all contained in the same table.

I understand I can do this through a 'no dax' method by unpivoting the table for all my chosen vairables, however given my data has 10m+ rows, i dont think this will be feasible.

Any advice would be greatly appreciated.