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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.