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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

Propagation of filters between tables.

I have the following tables and their fields that are used as PK and FK.

  • temp_simulacionoferta: pk_fecrutina_oferta
  • temppbi_resumenvariables: pk_fecrutina_oferta
  • temppbi_resumenevaluacion_dmcloud: pk_blaze_dmcloud and pk_fecrutina_oferta
  • temppbi_resumenvariables_dmcloud: pk_blaze_dmcloud

The fields are joined as follows:

  • temp_simulacionoferta with temppbi_resumenvariables, ratio of 1 to many by the pk_fecrutina_oferta field.
  • temp_simulacionoferta with temppbi_resumenevaluacion_dmcloud, ratio of 1 to many by the pk_fecrutina_oferta field.
  • temppbi_resumenevaluacion_dmcloud with temppbi_resumenvariables_dmcloud:, ratio of 1 to many by the pk_blaze_dmcloud field.

Now what I did was I have on a page charts that use fields from table temppbi_resumenvariables and table temppbi_resumenvariables_dmcloud.
I also have data slicers that use fields from the temppbi_resumenvariables table, what I want is that they can also filter the charts that use the temppbi_resumenvariables_dmcloud fields, to mention that the fields from the slicers are in both tables. The fields that are used in the slicers are not used in the charts, these slicers and their fields help to generate the filters and have views on the charts that were built

image.png

3 REPLIES 3
lbendlin
Super User
Super User

What is your question?

As I indicate, I want that when I apply a segmenter (the fields come from table temppbi_resumenvariables) this filter is also applied to graph 2 (the information comes from table temppbi_resumenvariables_dmcloud

image (1).png

Show a picture of your data model that has the full table names.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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