Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to have an option for a custom date range on a report as in the screenshot below.
The issue I have is if a user first selects a custom date range (UK based dates), e.g. 01/04/2018 to date (08/05/2018). and then selects a time period e.g. This Year, as in the screenshot below, the Custom Date Range filter still applys when selecting a Period.
What I want to happen is for the visual to only respect the Custom Date Range if Custom Range option in the Period slicer is selected or if nothing is selected in the Period slicer. I have a feeling the answer to this is going to be a no but thought I'd make sure.
I appricaitate that I can use relative date slicers and this ultimately might have to be the way I go but I'm trying to keep this as simple as possible for the end user and the Period slicer seems to be the way based off their feedback.
Solved! Go to Solution.
The May update resolved the issue (source: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#slicerSync)
Hi
As you referred, “the visual to only respect the Custom Date Range if Custom Range option in the Period slicer is selected or if nothing is selected in the Period slicer”
Create a calculated column
Column = IF ( [PERIOD] = "Custom Range", [date], BLANK () )
Assume the column added to the Custom Date Range slicer is named [date],
Then add this column to the Custom Date Range slicer instead.
Best Regards
Maggie
Hello Maggie,
Would you be able to attach an example .pbix file? What you suggest isn't working for me.
Thanks
Hi Maggie,
Thanks for that. Your suggestion does not work for me. When selecting Custom Range from the Period slicer the graph visual displays data. However when selecting any of the other options the graph appears blank.
The graph show be displaying data from another table.
The May update resolved the issue (source: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#slicerSync)
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |