Forum Discussion

fackert18's avatar
fackert18
Frequent Visitor
2 years ago
Solved

Blank Visuals when Cross Filtering on Matrix using Calculation Groups

I have a matrix that utilizes cacluation groups, with the matrix visual filtering on select items from the group.  In desktop, when i click on a row from the matrix, the other visuals cross filter as expected. However, in the PBI Service, when I click on a row to cross filter, the other visuals are blank.

 

Using web-edit in the service, I discovered that if i remove all filters of the calculation group on the matrix, the cross filtering works.

 

I suspect this is a bug since it works as expected in Desktop, and I just started noticing the issue recently in the Service. I have NOT made edits to the report since it was working in the service and when we started noticing the issue in the last week or two.

 

Screenshot 1: PBI Desktop. Default view. No cross filtering applied. Note my calculation group with filters for the matrix.

 

 

Screenshot 2: PBI Desktop. Clicking on a row from the matrix, confirming the cross filtering is applied to the visuals near the top of the page.

 

 

 

Screenshot 3: PBI Service, same cross filter applied. Visuals are blanked out.

 

Screenshot 4: PBI Service, edit mode. Removed the calculation group filter, clicked on a matrix row, and the cross fitlering is successfully applied.

 

 

 

Anyone know what might be happening?

  • This issue seems to have been resolved in the service after about a week. No changes on my end, so guessing MS did something on their side.

1 Reply

  • fackert18's avatar
    fackert18
    Frequent Visitor

    This issue seems to have been resolved in the service after about a week. No changes on my end, so guessing MS did something on their side.