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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
cflandez
New Member

Problema filtro para todo el informe. Filter issue for the entire report (All Sheets, all objects)

Hola a todos, tengo un informe el cual tiene varias hojas, estas hojas tienen distintas tablas o graficos que provienen de 5 Input diferentes(Tablas desde una BD en SQL Server).

Todas estas tablas o input tiene un campo en común "vchModel", el cual quiero utilizar para filtrar contenido en todas las hojas de mi Informe, el problema que tengo es que intento hacerlo mediante "Vista" > "Segmentación de Sincronización" > "Clickn en icono de sincronización y de view", pero el filtro no funciona en todas las Hojas del Informe, ni tampoco se aplica a todos los objetos del informe.

Luego intente crear las relaciones entre las 5 tablas en "Administrar Relaciones" > "Agregando cada relación" > "Dirección del filtro cruzado" > "ambos sentidos", pero esto tampoco funciona.

 

Existe algun otro metodo de utilizar este campo "vchModel" y que este afecte a las 5 tablas y a todas la hojas/objetos del informe.

 

Agradeceria de su ayuda.

 

Saludos 😃

 

--

 

Hello everyone, I have a report which has multiple sheets, these sheets have different tables or graphs that come from 5 different Inputs(Tables from a BD in SQL Server).

All these tables or input has a common field "vchModel", which I want to use to filter content on all sheets of my Report, the problem I have is that I try to do it by using "View" > "Segmentation Sync" > "Click on Icon of synchronization and view", but the filter does not work on all Report Sheets, nor does it apply to all objects in the report.

Then try to create the relationships between the 5 tables in "Manage Relationships" > "Adding each relationship" > "Cross filter direction" > "both directions", but this doesn't work either.

They know some other method for filtering using the field ("vchModel") and affecting the 5 tables and all sheets/objects in the report.

 

Thank you for your help.

 

1 ACCEPTED SOLUTION

Hi @cflandez 

 

I created a new table with the specific column, and manage the relationship with the other 3 tables:

Table = SUMMARIZECOLUMNS(Compras[vchModel])

09.PNG

Then drag it to filter all pages:

001.PNG

If you'd like to use slicer rather than filter to achieve it, please kindly refer to the Sync slicer: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicer... 

 

Pbix attached.

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

If possible please share a sample pbix file after removing sensitive information.
Thanks

Hello, I leave an example similar to what I have in my original report, what I need is to be able to filter with the field "vchModel" all the sheets of the report, in the example the first 2 sheets come from the Input "Example.xlsx", and the last Sheet contains information from " Example.xlsx" (Graph 2), and the rest comes from the Input "Example - Input2.xlsx".

The example goes without relationships, and without synchronizing the filters, because in the original report, this does not work for me. Would be grateful for any kind of help.

Best regards.

I don't know how to send the files or upload them to the forum, so I uploaded them to transfernow, it's 3 files, the 2 inputs and the report example

EXAMPLE PBI

 

_______________________

 

Hola, dejo un ejemplo similar a lo que tengo en mi informe original, lo que necesito es poder filtrar con el campo "vchModel" todas las hojas del informe, en el ejemplo las 2 primeras hojas vienen desde el Input "Example.xlsx", y la última Hoja contiene información desde "Example.xlsx" (Grafico 2), y el resto viene desde el Input "Example - Input2.xlsx".

El ejemplo va sin relaciones, y sin sincronizar los filtros, ya que en el informe original, esto no me funciona.

Agradeceria de cualquier tipo de ayuda.

Saludos.

 

 

Hi @cflandez 

 

I created a new table with the specific column, and manage the relationship with the other 3 tables:

Table = SUMMARIZECOLUMNS(Compras[vchModel])

09.PNG

Then drag it to filter all pages:

001.PNG

If you'd like to use slicer rather than filter to achieve it, please kindly refer to the Sync slicer: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicer... 

 

Pbix attached.

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Hello @v-diye-msft , I just tested the solution in the original report and it works perfectly, thank you very much for your help will be very useful for my other reports.

 

Best regards!!

Hello @v-diye-msft, I just reviewed the example and it works excellent, as soon as I can i do the proof in the original report, but I think with this option I will be able to solve my problem. Thanks a lot!!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.