Forum Discussion

jmscrx's avatar
jmscrx
Helper I
4 years ago
Solved

Relative Date - Axis Labels?

I have a simple set of tables with stacked column chart visuals. Now that I have more than 1 year of monthly data, I'm attempting to change the visual to show the most recent 12 months. As an example...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, jmscrx 

     

    You have two choice:

    • Manually drag the date column into the visual filter pane, and then you can also set the relative date in filter pane, and the data will still display the corresponding results.
    • Using custom format function in model view, set date format 'MMM YY', then you can get dates like 'Jan 21', This won't change your data type.

    Like this:

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

     

    Best Regards,

    Community Support Team _Janey