Forum Discussion
Field Name in Dropdown
I have a dropdown by using a slicer with year, month, and week fields.
Is there any way to remove the names of the selected fields (Year, Month, and Week) in this visual?
Hi joshua1990 ,
If you continue to use the current column settings, I'm afraid that the display of these fields(Year, Month and Week) on the slicer dropdown list can't be changed. You can create a calculated column below and apply it to the slicer instead of the Year, Month and Week fields.
SlicerDate = YEAR ( 'Date'[Date] ) & " " & FORMAT ( 'Date'[Date], "MMM" ) & " " & WEEKNUM ( 'Date'[Date], 1 )Best Regards
2 Replies
joshua1990
Unfortunately, you cannot rename or change that part of the visual. As an alternative, create a measure to show the desired results on a card visual.Selection Made = SELECTEDVALUE(Dates[Year] ) & ", " &SELECTEDVALUE(Dates[Month] & ", " &SELECTEDVALUE(Dates[Week]
Or you can rename the fields in the field well to some character.
I would suggest you open a new idea or vote for one if you find there:Hi joshua1990 ,
If you continue to use the current column settings, I'm afraid that the display of these fields(Year, Month and Week) on the slicer dropdown list can't be changed. You can create a calculated column below and apply it to the slicer instead of the Year, Month and Week fields.
SlicerDate = YEAR ( 'Date'[Date] ) & " " & FORMAT ( 'Date'[Date], "MMM" ) & " " & WEEKNUM ( 'Date'[Date], 1 )Best Regards
