cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 269 members 2,815 guests
Please welcome our newest community members: