I am working with power bi. I have a simple model with two tables with the same columns except one. The first one has the following columns: id, cicle, year and prod. The second one: id, cicle, year and res. When I include two cards to show: res and prod and I have a filter with one slicer, the slicer only change one card. The onde that is linked with the table.
| Id | Cicle | Year | prod |
| 1 | Dic | 2020 | 40 |
| 1 | DIc | 2020 | 20 |
| 1 | Jun | 2021 | 30 |
| Id | Cicle | Year | Res |
| 1 | Dic | 2020 | 1 |
| 1 | DIc | 2020 | 2 |
| 1 | Jun | 2021 | 3 |
Hi @TECPZR_1
In order for a slicer to work properly, the tables need to be linked by a unique value, which is not currently the case. Therefore, you need to create a 'years' table that will link the two tables and use it for the slicer.
Link to the file with an example
more information about modeling:
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @TECPZR_1
In order for a slicer to work properly, the tables need to be linked by a unique value, which is not currently the case. Therefore, you need to create a 'years' table that will link the two tables and use it for the slicer.
Link to the file with an example
more information about modeling:
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Helpful resources
Power BI Monthly Update - August 2025
Check out the August 2025 Power BI update to learn about new features.
Fabric Community Update - August 2025
Find out what's new and trending in the Fabric community.
