Dynamic meter goal

Hello @JuanDtM23

You must have a dimension table that makes the relationship between these two tables, which will make filtering and pivotchart possible.

Remember to use the dimension table indicator name in yourt visualizations and not the other tables, otherwise it will not calculate accordingly.

Hello @JuanDtM23

You can create a relationship between the Impact Indicator column in the Table1 indicator and the Column indicator in Table2 directly.

I build two boards for a test.

Tabla1:

Table 2:

Relationship:

Create one slicer per Impact Indicator column in Table1 and the results are as follows.

Default:

Select a

Select b:

Or like the MFelix response,you can create a dimension table with the indicator value and construct relationships between this table and Table 1 & & Table 2.

You can download the pbix file from this link: Dynamic Meter Objective

Best regards

Rico Zhou

If this post helps,then consider Accepting it as the solution to help other members find it more quickly.