Dynamic Target Line

[PowerBI123456]

Hi - is there a way to add a target constant line to a line graph that is depedent on the category. I have 15 different categories which each have a different target goal. Is there a way to change that target constant line automatically when I switch categories?

[amitchandak]

@PowerBI123456 , Create a meausre like

Switch(True(),

Max(Table[Category]) ="Cat1" , 30,

Max(Table[Category]) ="Cat2" , 40,

// Add so on

)

[PowerBI123456]

@amitchandak thank you! But it doesnt seem to be working. Could you provide a sample file please? Thanks so much!

[v-kelly-msft]

Hi  @PowerBI123456 ,

Check the similar thread below:

https://community.powerbi.com/t5/Desktop/Dynamic-constant-line/td-p/597459

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!