Forum Discussion

Tsanka's avatar
Tsanka
Icon for Kudo Collector rankKudo Collector
10 years ago
Solved

Visuals interaction slicer-matrix - strange behavior

Hi,   These days the interaction between the visuals in the service (and in the Windows app) behaves quite strangely. For instance, I have a horizontal slicer and a matrix (matrix filtered based on...
General Comment
  • Tishchenko's avatar
    Tishchenko
    10 years ago

    This bug occurs when "Auto-size columns" is Off. Can you check this on your reports?

     

    Demo from standart sample "Supplier Quality Analysis"

Tsanka's avatar
Tsanka
Icon for Kudo Collector rankKudo Collector
10 years ago

MCarmiggelt, thanks for your reply.

 

I have catched the possible bug in the attached screenshot.

 

So basically I have a report with a horizontal slicer for month/year. Initially I select "Dec 2015" and as seen in the screenshot, one matrix is not filtered and shows data for Dec 2015 and Jan 2016. Then (without changing the report and the iteraction between the elements), I have pressed again "Dec 2015" for clearing the filter and then pressed "Dec 2015" for setting it as a filter. Just then the matrix data were filtered correctly.

 

This is something that happens quite often, but not always.

 

Any ideas for solving will be more than welcome. Or if this is a bug, it would be nice the PowerBI team to say they will fix it soon.

 

BR

Tsanka

Tishchenko's avatar
Tishchenko
Icon for Responsive Resident rankResponsive Resident
10 years ago

This bug occurs when "Auto-size columns" is Off. Can you check this on your reports?

 

Demo from standart sample "Supplier Quality Analysis"

  • Tsanka's avatar
    Tsanka
    Icon for Kudo Collector rankKudo Collector
    10 years ago

    Hi Tishchenko and many thanks. I checked your suggestion and you are absolutely right - the bug occurs when auto-size of the columns is off.

     

    As kindly advised here, I registered the case, the guys tried to reproduce it with no success. Then I sent them a sample pbix where this bug is seen and I was waiting for their reply. I will send them the link to this thread with your observation and hope the team to fix the bug in the next releases.

     

    BR

     

    PS: I follow your posts in the community and I do believe that the PowerBI team has to give you a special award for finding bugs and for giving awesome ideas!    

     

     

    • larabraghetti's avatar
      larabraghetti
      Icon for Helper II rankHelper II
      10 years ago

      I have noticed the same issue. Any news about it?

      • Tsanka's avatar
        Tsanka
        Icon for Kudo Collector rankKudo Collector
        10 years ago

        Hi larabraghetti

         

        The issue is registered and filed by Microsoft as a bug. Attached is part of the answer of the support guy from MS:

         

        "I will proceed with filing this bug internally. Once there is a change, I will notify you. At this point I have no timelines or anything that can be publicly shared."

         

        Of course, when there is a feedback from Microsoft regarding this bug, I will share the info here

         

         

  • JenM's avatar
    JenM
    Icon for Advocate II rankAdvocate II
    10 years ago

    This is not a valid fix for the bug (which I experience too), as auto-sized columns themselves don't work. They often result in clipped text (...).

     

    Both these problems are pretty much deal-breakers for us!

     

    Interestingly, when you find yourself in the buggy situation (the matrix didn't refresh), 5 clicks on the very same slicer checkbox will ultimately get you back to the expected state. Go figure.