Forum Discussion

akhilduvvuru's avatar
akhilduvvuru
Icon for Helper IV rankHelper IV
2 years ago

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...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
2 years ago

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.

  • akhilduvvuru's avatar
    akhilduvvuru
    Icon for Helper IV rankHelper IV
    2 years ago

    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?