Dynamic meter goal

[JuanDtM23]

I have the following table with the estimated goals and maximos values several indicators:

the results of the indicators can be found in the following table:

the "result_Ind_Imp" column is the result of the indicator.

When creating the speedometer I associate the columns as shown.

In which I associate the columns "Tolerance" and "level 5_Imp" to a speedometer as seen:

the idea is that the target and the maximum value change each time the indicator name is selected in the data segmentation by indicator name, but it does not:

Any idea how I can do this?

Thank you in advance.

[MFelix · Accepted solution]

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.

[Syndicate_Admin]

I have 5 speedometers in three views of a board and the problem is that I leave the size of the format the same in all, but as the metric changes, the size changes a bit and the report does not look homegeno. Will there be any way to leave the size fixed?

[MFelix]

Hi @Anonymous ,

What you can do is to set the value directly on the options of the gauge chart:

Another option is to add a measure with a fixed value to your target values.

[Anonymous · Accepted solution]

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.

[MFelix · Accepted solution]

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.