The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
This is the outcome I would like to see