dynamic x-axis based on other slicer value selection
Hi Experts, I have following structure of the data. Data My customer wants to have dynamic x-axis based on Market. 1. When market is "Mid Size", they want to see a visual (bar chart) Customer/sales 2. When market is "Big", they want to see bar chart Region/sales in the same visual.
Kindly help me with this. Can it be done ?
Date, Customer Name, Market and Region are the slicers on the page. Thanks in advance