Forum Discussion
gdexter
8 years agoFrequent Visitor
Format Date Naming IMPOSSIBLE?
Dear Power BI Community, Reaching out for help, Below we have a list of dates. I would like to create a new column that simply contains the MONTH and YEAR information, in a "January 2016" for...
v-yuta-msft
8 years agoCommunity Support
Hi gdexter,
Remove the day level in your date hierarchy and check if it can meet your requirement.
Regards,
Jimmy Tao
gdexter
8 years agoFrequent Visitor
Hi all,
v-yuta-msft I have been able to remove the day level in my hierarchy when using a table (Image below), but what I really need is a dropdown slicer.
When viewing the date hierarchy for the slicer version, it only shows the year level (image below), is there a way to only show months and year in the filter?
Best,
Gdexter