Showing Month and Year

[stribor45]

I am trying to show a year number beside the month name but not having luck. As of now seems that my January is bunched up (January 2022 and January 2023) inside January. How would the visual show me a separate bar for January 2022 and a separate one for 2023?

Thanks

[vk_pbi · Accepted solution]

Hi @stribor45 

You should use custom date table to achieve all these options.

Under modelling tab, click New Table and paste this code

Dates = 
ADDCOLUMNS(
    CALENDERAUTO(),
    "Month No", MONTH([Date]),
    "Year No", YEAR([Date]),
    "Month Name", FORMAT([Date], "mmm"),
   "Month Year", FORMAT([Date], "mmm-yyyy")
)

Establish relationship between your fact table and this table. Now you can drag Month Year to axis in the chart.

You can find more videos on youtube