Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
jcastr02
Post Prodigy
Post Prodigy

Multiple goal lines dependent on selection in slicer

Goal AHT.pngI am needing a visual that will show average handle time by employee tenure, and by training type.   We have two different call types as well so I have a filter on the report page, and I would like the goal line to change based on the call type selected.   I have a measure created to move the goal line based on the "call type" (see below).  Right now I only have a line graph as I'd like to have each line represent the different "training types" , x axis - employee tenure and y - axis the handle time.  I can add a constant line but will not allow it to change based on the call type selection.  I also tried dropping the measure "goal AHT" into the values field but it doesn't let me have multiple values for line values

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@jcastr02 

 

Remove legend and drag measures below to Values.

Measure =
CALCULATE ( SUM ( 'Table'[AHT] ), 'Table'[Training Type] = "a" )

 

Measure 2 =
CALCULATE ( SUM ( 'Table'[AHT] ), 'Table'[Training Type] = "b" )

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-chuncz-msft    In the line graph, it doesn't allow me to have multiple entries in the "values" field.  I am trying to show a constant goal line if the call type is SAT enrollment , then the goal is 104, if SAT refill confirmation, then the goal is 99.  If you may please advise

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors