Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
my problem is
I have 2 slicers one is date range slicer(slider) & the other is year & month slicer
I have a requirement like if user is selecting a date in date range slicer it should show sum from calendar start date to user selected date & if the user is selecting year & month slicer then it should calculate the sum from calender start date to last date of year & month that user has selected
the real problem is
if we select year & month it also selects the range in date slicer(slider) so it only calculates for that month
so the ask is
month year slicer should filter date slicer(slider) but the measure need to be affected
we can't remove interaction between date slicer(slider) with the measure because we also calculate the sum when user select on slider too
Hi @newbie9 ,
I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your reply
I was able to solve this,
my expectation was my month year slicer shouldn't be bound to any date range, it should calculate sales from start to user selected date
I was able to accomplish by removing relationship between dim date & sales table using crossfilter fun
Now I need a solution for the below one,
This issue is bugging me for a month
I have also added screenshots
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |