Filtros de datos al seleccionar un dato en una matriz

[SoleyGomez]

Buenos días, genere esta matriz la cual con medidas calcula un volumen de solicitudes que tienen ese estado. Quisiera que al seleccionar el dato en la matriz, me salieran solo los datos asociados a esa medida.

[SoleyGomez]

Good morning, generate this matrix which, with measurements, calculates a volume of requests that have that status. I would like that when selecting the data in the matrix, only the data associated with that measurement would appear.

[Anonymous]

Hi, @SoleyGomez 

Thanks for rajendraongole1's reply. Already understand your needs, are you currently solving your problem? If not, would you mind sharing a pbix file of the simulated data without sensitive information for testing purposes.

Best Regards,
Yang
Community Support Team

[SoleyGomez]

Good morning, generate this matrix which, with measurements, calculates a volume of requests that have that status. I would like that when selecting the data in the matrix, only the data associated with that measurement would appear.

[rajendraongole1]

Hi @SoleyGomez - Thanks for the translation, 

In your situation, where you want the records associated with a selection in the matrix to become visible, this can be achieved by leveraging cross-filtering between the matrix and the table visual in Power BI.

Cross-filtering: By default, when you click on an element in a visual (like a matrix), it will filter other visuals (like your table) to display only the relevant data. This feature should work if both visuals are linked by a common field. Make sure that the data in the matrix and the table is connected, likely by the same status or case number.

Set up interactivity:

Ensure both the matrix and the table visual are based on the same dataset or have relationships defined properly between the related tables in the Power BI model.

Check if cross-filtering is enabled for your report. This can be done by selecting the visuals, clicking on the "Format" pane, and ensuring that "Edit Interactions" is configured to allow filtering between the visuals.

If the filtering isn’t working as expected, try the following troubleshooting steps:

Verify that relationships between tables are properly set up in the data model.

Ensure that filter context is applied correctly by testing the selection on simpler visuals.

ref solved thread:

Solved: Enable cross-filtering and cross-highlighting in t... - Microsoft Fabric Community

Understand how visuals interact in a report - Power BI | Microsoft Learn

Filters and highlighting in Power BI reports - Power BI | Microsoft Learn

[rajendraongole1]

Hi @SoleyGomez - can you please translate/post the query in english language for better visibility and also share the sample data file or pbix file by removing the sensitive data.

Thank you.