How to display month instead of date in column

[Orange2045]

Dear all, i would like to show the amounts invoiced by vendor by month in column

1) how can i display by month instead of date?

2) how can i only show the months of  2021 et 2022 ?

i already created a table of "date" and established a relationship between the table of  "vendor and "date" by documents date

Thanks for your help, 

Annie

[Orange2045]

yes i creat a calendar dimension table 

[JorgePinho · Accepted solution]

Then for problem number 1), use a Month field from that dimension table in the visual instead of the Date field .

For number 2) you can either add a slicer with the Year field (of the calendar dimension) and select 2021 and 2022 or use the same field in the Filter Pane.

[JorgePinho]

Do you have a calendar dimension table?