Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |