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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
muhitdinfa
New Member

Line Graph With the Average of TOP 3 and/or Bottom 3 N Comparing Against The Selected Choice

I am trying to create a line graph where I want to see 3 lines in the graph in the same visual:
1st line - the average price of Top 3 Brokers

2nd line - the average price of Bottom 3 Brokers

3rd line - my selected Broker's price

 

 

12:00pm

13:00pm

14:00pm

Broker A

12.55

15.32

14.78

Broker B

13.82

14.22

13.05

Broker C

21.73

13.32

12.98

Broker D

18.83

19.25

15.50

Broker E

19.55

16.77

12.91

Broker F

14.65

12.85

13.01

Broker G

11.24

15.02

13.04

Broker H

12.95

14.97

11.78

Top 3 AVG

20.0366

17.1133

14.4433

Bottom 3 AVG

12.2467

13.4633

12.5567

 

One of the biggest challneges is that I want to exclude the selected Broker out of top/bottom 3. For example, if I want to compare Broker D against the average of top/bottom 3, Broker D shouldn't be included in the calculation of top/bottom 3. I am not sure if it's possible in PowerBi, but would be great to have that option in there. 

 

1 REPLY 1
muhitdinfa
New Member

This is the outcome I would like to see

 

example.png

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.