Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
4 years ago
Solved

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?  
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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