cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Voose Member
Member

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

Accepted Solutions
prateekraina New Contributor
New Contributor

Re: Text field to show the selected filter(s)

Hi @Voose,

 

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

 

Prateek Raina

Community Support Team
Community Support Team

Re: Text field to show the selected filter(s)

@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.
3 REPLIES 3
prateekraina New Contributor
New Contributor

Re: Text field to show the selected filter(s)

Hi @Voose,

 

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

 

Prateek Raina

Community Support Team
Community Support Team

Re: Text field to show the selected filter(s)

@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.
Voose Member
Member

Re: Text field to show the selected filter(s)

@v-chuncz-msft@prateekraina

 

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

 

Thanks

 

Voose

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 41 members 888 guests
Please welcome our newest community members: