Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
joshua1990
Post Prodigy
Post Prodigy

Field Name in Dropdown

I have a dropdown by using a slicer with year, month, and week fields.

joshua1990_0-1632043297626.png

Is there any way to remove the names of the selected fields (Year, Month, and Week) in this visual?

 

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

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 )

yingyinr_0-1632289034119.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

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 )

yingyinr_0-1632289034119.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Fowmy
Super User
Super User

@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.
Fowmy_0-1632044264592.png


I would suggest you open a new idea or vote for one if you find there: 

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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.