I am trying to use two slicers in Power BI to select the StartYear and EndYear columns for a column chart.
The only two bars on the chart will be the sum of revenue for the selected two years.

I’ve tried using two separate tables connected to a common one, with one-to-many relationships and cross filtering in one direction, but that won’t work.
(https://i.sstatic.net/8jtVJITK.png)

This is what I want the chart to look like, with two single-select slicers instead of one multi-select.(https://i.sstatic.net/KhJP5nGy.png)