Field Name in Dropdown

[joshua1990]

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?

[Anonymous · Accepted solution]

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]

@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/