Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I 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
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" )
@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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.