Forum Discussion

cdcphist's avatar
cdcphist
Frequent Visitor
5 years ago
Solved

Custom sorting changes values in matrix visual

Hi,   I have a matrix visual in my dashboard that appears correctly so long as a don't try to order the rows by a custom sorting column. If i try to do that, the values change all to 100% (which sh...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    cdcphist your problem is the measure that uses  probably allselect or all function and if you sort by it has an impact, well explained here

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
5 years ago

cdcphist your problem is the measure that uses  probably allselect or all function and if you sort by it has an impact, well explained here

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

cdcphist's avatar
cdcphist
Frequent Visitor
5 years ago

Thanks, i tried your solution and although it makes sense to me, the values still don't appear correct:

 

 

  • cdcphist's avatar
    cdcphist
    Frequent Visitor
    5 years ago

    Just to add that i misunderstood the solution, it was necessary to include the order column in the all function.

     

    Thank you.