Text field to show the selected filter(s)

[Voose]

Hi All,

For each Quarter of sales I have a slicer that splits the deals into their different forecast categories laid out as per below:

Q1

Won - Forecast - Other (SlicerQ1)

Q2 

Won - Forecast - Other (SlicerQ2)

Q3 

Won - Forecast - Other (SlicerQ3)

Q4

Won - Forecast - Other (SlicerQ4)

NFY Q1

Won - Forecast - Other (SlicerQ5)

What im trying to create is a measure that will sit in a card just to display a which current slicer is selected I.e. if i click on Won in Q1 then I want the card to display Q1 - I've been trying to do this with the HASONEVALUE however when i click on Q2 and select something it still says Q1 because Q1 still only has 1 value (Won) because where we are in the year)

After I have 1 card showing the Quarter I then want a second card showing whats been selected i.e. Won / Forecast ... At the moment I think I could just do this using the values that are avaliable for that column...

Any help appreciated

Thanks

Voose

[prateekraina · Accepted solution]

Hi @Voose,

Try using VALUES function, it holds the current value of slicer.

Prateek Raina

[Voose]

@v-chuncz-msft@prateekraina

Thanks guys, feel so silly after reading your responses, it was so obvious!

Thanks

Voose

[v-chuncz-msft · Accepted solution]

@Voose,

Instead, create a table with two columns [Quarter] and [Category], then add two slicers for them.

[prateekraina · Accepted solution]

Hi @Voose,

Try using VALUES function, it holds the current value of slicer.

Prateek Raina