Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Voose
Helper III
Helper III

Text field to show the selected filter(s)

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

2 ACCEPTED SOLUTIONS
prateekraina
Memorable Member
Memorable Member

Hi @Voose,

 

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

 

Prateek Raina

View solution in original post

v-chuncz-msft
Community Support
Community Support

@Voose,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Voose
Helper III
Helper III

@v-chuncz-msft@prateekraina

 

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

 

Thanks

 

Voose

v-chuncz-msft
Community Support
Community Support

@Voose,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
prateekraina
Memorable Member
Memorable Member

Hi @Voose,

 

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

 

Prateek Raina

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.