Hi,
We have dynamically change x-axis values based on slicer selection on chart visulazation.
Slicer:
Months
Weeks
Day
Where date table have day as date data type and Month and Week as text data type, how to achieve the requirement. how can I dynamically display x-axis based on slicer selection?
I know, we have two solutions, once using duplicate the date table and unpivot and use the attribtues and values.
Other solution, create three visualization render the chart visualization based on slicer selection.
