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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.