Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI, I have a Slicer with Year with Quatter. Very Old Year from 1974, This is the situation:
1. I want to show only the last 2 year (2016 - Q1, 2016-Q2, 2016-Q3, 2016-Q4, etc..) in the slicer,
2. But in the chart I need all old information
If i choose 2016-Q4, see all the data from 2016-Q4 and Oldest Data.
If I choose 2017-Q1, see all the data from 2017-Q1 and oldest data.
Any advise, suggest, is very welcome.
Hi @sixtoquiles
You could use the measure below, which will always get the value you have selected on your slicer
Oldest Date Selection = CALCULATE ( [Headcount], FILTER ( 'Table Name', 'Table Name'[QY] <= LASTNONBLANK ( 'Table name'[QY], [Headcount] ) ) )
Then what you could do on your slicer is to filter it out, so that it only shows the values for the last 2 years. And then change the Interactions so that it will not interact with the visual. And in theory this should work because the measure will take into account what has been selected on the slicer.
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |