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.
I have a table "DateTable" that looks like the following:
Note that the Fiscal Year is running from April 1st to March 31st in this case.
I have a single select slicer for the "Fiscal Year" column, and I would like that slicer to influence the selection of a slicer on the "Date" column. It should look like this - when a Fiscal Year is selected, the range of the dates on the Date slicer should default to the start and end of that Fiscal Year (e.g. in this case 1st April 2021 - 31st March 2022):
Is there any way to achieve this, perhaps with the use of Measures?
Here is a sample PBIX file: sample.pbix
Many thanks!
Solved! Go to Solution.
Go to Format --> Edit interactions, click on the Contract Year slicer, and click the chart icon on the Date slicer:
Proud to be a Super User!
Go to Format --> Edit interactions, click on the Contract Year slicer, and click the chart icon on the Date slicer:
Proud to be a Super User!
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |