How can I remove the hierarchy for dates inside a matrix(Table)?

[HamidBee]

I'd like to remove the hierarchy for the dates inside this table so that it shows for example:

August 2021 instead of 2021-> August.....

Essentially I am trying to remove the drop down.

Any help would be greatly appreciated.

Thank you

[v-easonf-msft · Accepted solution]

Hi, @HamidBee 

You can also convert the date column to the format 'mmmm yyyy'.

Then cancel the use of 'date hierarchy' in your matrix visual.

Result：

Best Regards,
Community Support Team _ Eason

[aj1973]

Hi @HamidBee 

You will need to add a column MonthYear to your date/fact table