Forum Discussion

jabbajuice08's avatar
jabbajuice08
Frequent Visitor
3 years ago

Creating three slicers with the same values for different time periods that affect one line

I have one graph that has a dynamic line on it that changes based on one of the parameters selected by users (High, Medium, Low). Once selected, each parameter will change ONE part of my line graph. 

 

My line graph has Dates from 2020-2026 on the x axis and Dollars on the y axis and sums up the total cost for each task. I have a measure I am using as my line [**bleep** BCWP]. Basically, I want to have three slicers at the top for Near Term (0-60 days), Middle Term (61-90 days), and Long Term (past 90 days). Each of these slicers have High, Medium, and Low selections. However, when selected, they only change one part of the line, depending on the time frame. So I need to make a conditional measure that changes the Month/Year of each task depending on user selection of each of the three slicers. So if a user selected "High" in the Near Term Slicer, it will only change the finish dates for those tasks that are within 0-60 days and leave everything else the same. How would I generally go about doing this? What steps would I have to do/dax statements to make this work? Thank you!!