For each Quarter of sales I have a slicer that splits the deals into their different forecast categories laid out as per below:
Won - Forecast - Other (SlicerQ1)
Won - Forecast - Other (SlicerQ2)
Won - Forecast - Other (SlicerQ3)
Won - Forecast - Other (SlicerQ4)
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...