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 |
1 ACCEPTED SOLUTION
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
