Forum Discussion
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
- fackert18Frequent 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.