Relative Content

Tag Archive for powerbidaxpowerquerydata-analysispowerbi-desktop

Power BI Remove year in Chart visual x-Axis but sort by month and year

In my data I compare the sales amount of diferent years but to show them in the same chart, I faked the year in my data. It always start in 2000.

The legend shows the name of the SalesEvent.

My sorting of the x-Axis works perfekt if I use the date-hierarchy.

But if I remove the year from the date-hierarchy the sorting fails and adds e.g. December into one x-Axis-Point.

Is it possible to let the visual look like the upper one, only without the fake year?
Please let me know