Forum Discussion
year-month in a visualization
Hi, i am trying to build a graph with year-month in the x but as i have a jerarchy i have to choose year or month. I want to see both because i have information of different years, for example, from ...
You need to create a YearMonth column in your Date table with something like FORMAT('Date'[Date], "yyyy mmm"). FYI that this article has DAX you can copy to get a table with that. It also has special hidden characters so that they show in the correct order in your visual (w/o a Sort By column). Note you may have to replace the minus signs in the code as it didn't render correctly on the web site.
No Sort Date Tables! – Hoosier BI
Pat