Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a data table with a Start Year Column and End year Column I want to be able to Create a slicer that when I select a year it finds all rows between or equal to the start year and below or equal to the end year. Im not sure if creating a seperate key table with the years that I would be able to select from and linking it by some comparison.
Year Comp 2 is just a seperate Table with possible years I would like to be able to slice by.
Table 1
Table 2
Solved! Go to Solution.
Hi @Zfilter ,
Has your problem been solved? If it is solved, please mark a reply which is helpful to you.
If the problem is still not resolved, please try the following measure:
Measure =
VAR yearcomp =
SELECTEDVALUE ( 'Table 2'[Year Comp 2] )
RETURN
IF (
yearcomp = BLANK (),
1,
COUNTROWS (
FILTER (
'Table 1',
'Table 1'[StartYear] <= yearcomp
&& 'Table 1'[EndYear] >= yearcomp
)
)
)
Then in the visual-level filter, show items when the Measure is 1.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Zfilter ,
Has your problem been solved? If it is solved, please mark a reply which is helpful to you.
If the problem is still not resolved, please try the following measure:
Measure =
VAR yearcomp =
SELECTEDVALUE ( 'Table 2'[Year Comp 2] )
RETURN
IF (
yearcomp = BLANK (),
1,
COUNTROWS (
FILTER (
'Table 1',
'Table 1'[StartYear] <= yearcomp
&& 'Table 1'[EndYear] >= yearcomp
)
)
)
Then in the visual-level filter, show items when the Measure is 1.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Feed your slicer from 'Table 2'[Year Comp 2] (keep that table disconnected from your data model) . Create a measure that implements your logic against SELECTEDVALUE('Table 2'[Year Comp 2]). Then add that measure to the page level filters.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
9 |