Forum Discussion

GunnerJ's avatar
GunnerJ
Icon for Post Patron rankPost 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

GunnerJ's avatar
GunnerJ
Icon for Post Patron rankPost Patron
6 years ago

KBO 

Here'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's avatar
KBO
Icon for Memorable Member rankMemorable 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
    Icon for Post Patron rankPost 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
      Icon for Memorable Member rankMemorable 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