Forum Discussion

mehlenbae2's avatar
mehlenbae2
Icon for Helper II rankHelper II
3 years ago

Need graph to show same target for different year

So I've been keeping a historical data set to track Refresh Deployments and I have a filter that you can toggle 2022 or 2023. However the target is still the same from 2022 for all three regions. When I filter to 2022 I see that AP has met their target 100% (see figure 1) however when I filter to 2023, the count of deployments restarts and AP is no longer 100% of their target (Figure 2). I dont want my PBI to show that they haven't met their target just when I click 2023 because the targets are the same and the deployments should carry over from 2022. How can I achieve this?

 

Measures: 

Refresh Pending = IF('Refresh'[Refresh Completed] >= SELECTEDVALUE('Refresh'[Target]), //If reached target
    0,    //Nothing is pending
    SELECTEDVALUE('Refresh'[Target]) - 'Refresh'[Refresh Completed]  //Else calculate pending
)
 
Refresh Completed = SUM('Refresh'[Count])
 

 

Figure 1:

 

Figure 2: 

 

Figure 3: 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi mehlenbae2 ,

    I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu

    • mehlenbae2's avatar
      mehlenbae2
      Icon for Helper II rankHelper II
      3 years ago

      Hi there,

      So when I filter to a different year (this year 2023) the progress for refresh deployments starts back at 0 (see Figure 3). I would like it the progress to stay the same as if it was not filtered at all, I want my results to stay as Figure 1) regardless of year change. I have other visuals that I want to change with Date filters just not the two shown above.