Forum Discussion
Year Column will not group
I have created a column using the expression Year = 'tableName(") ' [month]
When I dropdown the column Year it shows individual dates and not just the year, when I create a slicer it shows
multiple values for each year instead of grouping them. Thanks in advance
5 Replies
- PattemManohar
Community Champion
hanmcm Not sure, whether your calculation to "Year" column is correct. I can see slightly from the screenshot, your Year column is still showing a date value.
Hi I have the year column set to (yyyy), should the whole date still appear even with this format
- PattemManohar
hanmcm It should Year value only if your intention is to extract year value from the date field...
Please try adding a new column using "Column From Examples" which will help you to add the logic behind....
I can see slightly from the screenshot, your Year column is still showing a date value.
