Forum Discussion

GunnerJ's avatar
GunnerJ
Post Patron
6 years ago
Solved

Change 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...
Need Help
Tutorial Requests
  • KBO's avatar
    KBO
    6 years ago

    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's avatar
KBO
Memorable Member
6 years ago

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

GunnerJ's avatar
GunnerJ
Post Patron
6 years ago

KBO I guess I'm a bit confused on how to use the selectedvalue function to grab a value not shown in the filter. I understand they're on the same line so there's a connection there but do you have an example of that being used?

  • KBO's avatar
    KBO
    Memorable Member
    6 years ago

    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