Some chart types we can only use one dimension in X axis, then I am thinking whether we translate the dimension to measure for example
Dimension-X axis - Year
Measure - Sales for Groceries, Sales for Furniture, Sales for Clothes.
If category is fixed, we can use function case but in fact our data has thousands types.
Is there a way to use function case together with selected value from filtered list. e.g. Catetory A, B, D are selected then we can use case when sales [caterory.list] etc.
Just try to think how to make it work
Thank you very much.