Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
Solved! Go to Solution.
You could just create a slicer column with +1 to the date year.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
You could just create a slicer column with +1 to the date year.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@amitchandak Thank you, but dynamic titles/headers/cards are not an option either.. I have to change slicer names
@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
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |