Forum Discussion

RaulPBI's avatar
RaulPBI
Helper II
6 years ago

Put a second order in a table visual

hi all,

 

I want to ask you about something that it could be easier, but I am not able to find the solution.

I am working with a table in which I have established an order based on a hierarchy. The thing is that I want to give a 2nd order based on the amount of each item, without losing the first order.

 

In the example, I need that Bankinter appears on top of its item (financiacion compras) because has the most amount. Then it would be appear caixabank and so on.

 

Any idea about how to fix that? Thank you in advance.

Need Help

1 Reply

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi RaulPBI,

    According to your description, it seems that you want to have interactive sorting in Matrix PowerBI, right? As I know, the Matrix will sort by the column grand total, there is no interactive sorting in Matrix of PowerBI currently(if you sort on  Jan month, I think the Feb month won't sort correctly, there is no interactive sorting in PowerBI currently). I suggest you could post the requirement in power-bi-ideas .

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.