I created the report to embed in sharepoint. With "Edit Interacation", I wanted to filter the other tables and cards based on the selection in the matrix which is shown in the attachement. It works properly in Edit Mode and Preview mode in Power BI Service. When I select the some of the cells in matrix, it filters the other components, so it works good.
But it doesn't work when I embed the report in sharepoint. When I select any cells on the first, second, and third rows in matrix on the report embeded in sharepoint, it works good. But, when I select any cells on the fourth and fifth rows, it doesn't filter at all.
I also have the other matrix on the same report, and it also doesn't work in embeded report. The matrix have the three rows and five columns with one measure with count function and conditional formatting too, and only the third row is not working properly. As the same as above, this matrix also perfectly works in Edit mode or Preview mode.
I feel like this is a bug.
The datasource is from excel using "Import Excel data into Power BI".
The Row and Columns have just one dimension respectively, and the value has the ID which is measured with count(distinct) function.