Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Fixed line in line graph

Hi peeps   I have a link graph which is affected by an array of slicers however I do not want one of the lines to be changed when slicers are changes. My example is in the below. I want the "DPS Av...
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    In your fomula below, you add a extra symbol "{", it caused the error.

    Additonally, you should use the allexcept function, otherwise the fixed line value is the same for each date.

    If the Axis of the line chart is [Date], modify the formula like this:

    Fixed Line =
CALCULATE (
    [DSP Average],
    ALLEXCEPT ( 'Unscheduled Leave', 'Unscheduled Leave'[Date] )
)

    Get the correct result in my sample.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Unfortunately this still isnt working 😞 I have duplicated the meausre as one measure needs to capture all (with as you mentioned above the parenthesis) and one that is affected by the slicer but it picks up for both

 

My measure is 

Average Days Per FTE - rolling 12 Months =
VAR STARTDATE =
CALCULATE ( STARTOFMONTH('Unscheduled Leave'[Cal. year / month]) )
RETURN
CALCULATE (
DIVIDE ( SUM ( 'Unscheduled Leave'[Actual Days]), SUM ( 'Employee Master'[FTE - Operational] ) ),
DATESINPERIOD ( 'Report Date'[Date], STARTDATE, -12, MONTH)
)*12
 
 
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ，

Sorry I'm not very clear "one measure needs to capture all" and "one that is affected by the slicer but it picks up for both".

In your original post, you want the "DPS Average" to not change but the others to change, so when you replace the DPS Average with the Fixed Line, what happend? Does it still change by the slicer?

 

Best Regards,
Community Support Team _ kalyj

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    So what I mean is that I have three slicers - Division, Branch Section. I have the same formula for two meausres. One i want all Division, Branch section to be fixed and not changed. But my slicers (Division, Branch and Section) change the other measure. Does that make sense?