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
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |