Multiple charts with individual Native query and how to have common filter for all charts

[Anonymous]

Hi,

I have created multiple charts using individual native query. These query has commom field and need to have one filter setup using the common field. Please advise on how to achieve this.

Thank you!

[TomMartens]

Hey @Anonymous ,

having a native query per visual means, you x tables if you x visuals.

Now, create a single table that extracts the values from the visual-queries and create a separate table, make sure that the values are unique. Use this table to create relationships between the "filter" table and the visual-tables (https://learn.microsoft.com/en-us/fabric/data-warehouse/data-modeling-defining-relationships?WT.mc_id=DP-MVP-5003068).

This will form a semantic model, basically the "filter-tables" are often called dimension tables, when your are following the star-schema modeling approach.

If you are new to data modeling for Power BI, I recommend this learning: https://learn.microsoft.com/en-us/training/modules/design-model-power-bi/?WT.mc_id=DP-MVP-5003068

Hopefully, this helps to tackle your challenge.

Regards,

Tom