Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
SoleyGomez
Helper I
Helper I

Filtros de datos al seleccionar un dato en una matriz

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_3-1728045698029.png

 

 

5 REPLIES 5
SoleyGomez
Helper I
Helper I

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.

 

SoleyGomez_0-1728493187341.png

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
Helper I
Helper I

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.

 

SoleyGomez_0-1728493187341.png

 

 

 

 

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

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





rajendraongole1
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.