Dynamic Target

[daniellf]

Hi all!

I'm showing some results compared to a target in a gauge visual, however I would like to make the target only show when very specific filter options are selected - is there a way to do that through measures? For example, we are displaying the results for populations A through Z, but I only want the target to show if A - D are selected, it cannot be just A, just B, or any other combination. 

Also, my target value right now is just the average of a column in my report - could I create a dynamic target that responds to more than one filter and is easier to adjust (right now I just make sure the column is averaging the way I need but this is manual)?

Any tips or ideas would be great! Thanks 🙂

[DataZoe · Accepted solution]

@daniellf ,
you could do this by using the quick measures concatenate then checking to see if it's concatenated the values in the right combination to find the combination.  Using that info, you can create a target with an if statement to change it out when it's found.

Target =

if([List of Slicer values] = "A, B, C, D",

80,

[All Average])

I've attached a PBIX with this so you can see!