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 should be the sum of the column and not all the values).

 

 

 

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.⚡

4 Replies

  • 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.