Forum Discussion
GunnerJ
Post Patron
Post PatronChange Filter Value names
I have a set of filters that I'm hoping the end user can use to select values to be used in a calculation. The values are for certain years so I'd like to show the year instead of the value as it may...
Hi,
here you see the original Table with the data. In the second picture you see the table visual with the values and the years also a slicer with the years. In the third picture you see how I activate the filter and you see it works. The visual only shows the value for 2016.
Best,
Kathrin
KBO
Memorable Member
Memorable MemberHi,
do you have a date column in your table or instead a date dimension in your model? Than you can use this instead of the value.
Best Kathrin
GunnerJHere's the table in question. I do have a date column for the year. In the Equity Column you can ignore the year I put in before the number. I was just experimenting.
- KBO
Than its easy - put the years as value in the filterpane or in the slicer and you can filter after the Values in one specific year :)
Best Kathrin