Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sort bubble size by multiple legends?

Hi,   I am fairly new to Power BI and only know basic programming, so I might have missed the solution in my searches. I will try to explain the best I can...   I am creating a bubble chart to a...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello again,

     

    I believe I have solved it.

     

    I took out another Excel from our ERP with that summerized the total Cost for each Order No. and Order Type, set the Relation between Order No.

    So far, it seems to be correct. 

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You are using order type as legend, why are you using order type filter in measure

Profits by Order type =
CALCULATE(
SUM('EarningsTable'[Profits])
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Yes, because customers can purchase from all order types and I need to see the profits of each order type.

    If I use 'EarningsTable'[Profits] it displays the same earnings for each bubble. I believe this is because it sums all profits for that Customer. I want it to be sorted by Customers and Order Type.