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

Fowmy's avatar
Fowmy
Super User
4 years ago

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: 

https://ideas.powerbi.com/ideas/