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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
tuulia
Helper IV
Helper IV

Change member names in slicer

Hi!

 

I have a requirement to change slicer member "names".

 

Example: I want a report to show data from year 2020, but slicer should show this selected year 2020 as "2021".  Or when I want to show year 2019 I select year "2020" from slicer. How can I achieve this?

 

I can't use report headers etc - my only option is to change slicer member names/labels (like in SSRS/any-other-reporting-tool)

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@tuulia 

 

You could just create a slicer column with +1 to the date year. 

 

Year Slicer(new) = YEAR([Date])+1
 

V-pazhen-msft_0-1609208788441.png


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

 

View solution in original post

4 REPLIES 4
tuulia
Helper IV
Helper IV

@V-pazhen-msft  thank you, I think this will do the trick!

V-pazhen-msft
Community Support
Community Support

@tuulia 

 

You could just create a slicer column with +1 to the date year. 

 

Year Slicer(new) = YEAR([Date])+1
 

V-pazhen-msft_0-1609208788441.png


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

 

tuulia
Helper IV
Helper IV

@amitchandak  Thank you, but dynamic titles/headers/cards are not an option either.. I have to change slicer names

amitchandak
Super User
Super User

@tuulia , You can display somewhere, but can not change the selected value. 

 

Selectedvalue(Table[Year])

 

You can display card, Title : (Dynamic Title)
https://www.youtube.com/watch?v=TYLKDPcvgK8
https://www.blue-granite.com/blog/create-a-dynamic-title-in-power-bi-updated

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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