Forum Discussion

JanvanderHilst's avatar
JanvanderHilst
Frequent Visitor
4 years ago

Matrix visual printing last section twice? (Bug?)

Hi Guys,

 

Compliments of the new year. 

There something weirds going on in my Matrix in my Power bi report.

 

What I have done thus far is created a table structure which specifies the rows in my matrixs (Note that each line can/should reflect a different value  for example: Unit price, total cost , profit.)

 

The value in the matrix is filled with a measure which contains a switch case, resolving different calculations based on the selected row value. (note that it resolves these caculations pretty quickly, and updating the matrixs takes no longer than 1 sec)

 

Issue that I am facing now is that sometimes it prints the bottom rows twice? And sometimes it does not?

See the first 2 screenshots of March and April, showing the Profit section once.

See the last screenshot of April again, showing the profit section twice.

(This happens randomly which switching between the monthts)

 

When it happens, the matrix "Freezes" very briefly and I have to make an additional scroll montion inorder to go to the bottom.

So I am leaning towards a performance bug?

 

Has anyone seen this before? And what could be a good solultion, as my client is not liking this.

 

Thanks in advance

Jan

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Maybe it helps to clear cache?

    Go to Options and Settings -> Options 

    Then select Global -> Data Load and scroll down to Data Cache Management Options and press 'Clear Cache'

     

    • JanvanderHilst's avatar
      JanvanderHilst
      Frequent Visitor

      Hi, 

      Does not resolve the issue.

      Note that this also happens when published to the online version.

  • JanvanderHilst what column you are using on the rows can you make sure that value is not listed twice in your table. Are these values coming from a dimension table?

    • JanvanderHilst's avatar
      JanvanderHilst
      Frequent Visitor

      Hi Parry2k,

       

      Table is just a static typed table in the power query. It looks like this:

      Note that column 1 and 3 are used to sort the ordering when displaying:

      (the # are the ordering, have set the width of the column to zero to not display them)

      Columns contain Item related information

       

       

       

       

       

       

  • JanvanderHilst I think the first # column you are using for order, maybe some of the profit lines don't have the same order number value, can you double-check that.

     

    Follow us on LinkedIn and subscribe to our YouTube channel

     

    Learn about conditional formatting at Microsoft Reactor

    My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.

    • JanvanderHilst's avatar
      JanvanderHilst
      Frequent Visitor

      They are all the same: 

      If they were not, it should also not be random (as in, it is displayed correctly like 50% of the times)

       

       

    • JanvanderHilst's avatar
      JanvanderHilst
      Frequent Visitor

      Hi Parry, 

       

      Removing sensitive data will be difficult as most of it is financial data coming from their system.

      If you'd like I can show you via a Teams call?

       

      Kind regards 

      Jan van der Hilst

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi JanvanderHilst ,

    Have you solved the issue? I cannot reproduce the problem. Please try to resize report pages. If it does not help, please provide some sample data , remove sensitive information before sharing. 

     

    Best Regards

    Community Support Team _ Polly

     

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