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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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