Forum Discussion
Dynamic X-Axis Date format change
Hi Team, I have a requirement to change the format of my bar chart x-axis (Date Field). I have a Period selection in my report with 3 values (Last 10 Days, Last 6 Months and Last 5 Years). So bas...
You could do it with bookmarks, have a bookmark for each granularity and use a bookmark navigator to allow user selection. You would have 3 charts, one for each level and each bookmark would show the one you want and hide the other 2. You would also set the date range filter on each of the charts, so the right amount of data is show.
Thanks for your response jdbuchanan71 - True, Bookmarks will work but also comes with good amount of maintainence efforts. I'm keeping Bookmarks as my last option.
Do you think of any other alternative approach using DAX?