Forum Discussion
Creating a dynamic filter in Matrix table
This seems to be solution I might be looking for, but could you please help me creating same without any table as we are not allowed to do so. That will be great help I think that might required chnages in report has selected source system.
Hello jainmohit_0710,
Thank you for posting your query in the Microsoft Fabric Community Forum.
If a disconnected slicer table cannot be created, using System Name as both slicer and Matrix columns is not recommended, as Power BI will filter the column axis and may collapse system columns.
If you are not able to create a separate table in your environment, as a workaround Systems can be represented as individual measures instead of columns, with Report ID in rows and each measure evaluating system membership from the ReportSystemMapping table (returning 1/0).
This approach works for small or static datasets only, as it is not scalable and requires manual maintenance for each new system.
Overall, the disconnected slicer pattern remains the best practice for scalable and reliable models.
please Refer below pbix file.
Thank you.