Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Instead, create a table with two columns [Quarter] and [Category], then add two slicers for them.
Thanks guys, feel so silly after reading your responses, it was so obvious!
Thanks
Voose
Instead, create a table with two columns [Quarter] and [Category], then add two slicers for them.
User | Count |
---|---|
101 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |