Forum Discussion
Static matrix Column Header (without slicer impact)
Hi Team, My Date table is joined with Sales Table.Sales Table contains one dimension field which is also slicer for the report page.I have created matrix with Quarter(Column Header from Date table) ...
hi shashankp1 - Have you tried to edit interactions between the slicer and the matrix visual so changing the Qaurter slicer does not impact the matrix visual
You can refer to the Microsoft documentation on the same:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Please mark the above comment as a solution to help others find it more quickly. Also please provide a 👍 if my comment helped with solving your issue. Thanks!
Hi Sumath.Thanks for your reply but I cannot do edit interaction as it will not change Sales Amount.I want sales amount should change as per slicer but header should remain static & will show blank Sales value where related value is not present.Hope you got my problem.