Replace Values in a field with Values from a different Value from a separate connected sheet

[Lulaz]

Hi,

I have a Mastersheet sheet containing a column RULE_NAME. In a second sheet I have two columns only, a sort of translation guide, made up of RULE_NAME and RULE_Translation. I have linked the two RULE_NAME columns together via relationship manager.

I want in a barchart showing the count of any RULE_NAME occuring, but on the axis, show the RULE_Translation for the RULE_NAME instead of the original RULE_NAME Value.

Is this possible?

Thanks,

Lulaz.

[v-sihou-msft]

@Lulaz

In this scenario, what's the relationship between Rule_Name and Rule_Translation?

If that's one-to-one relationship, you can directly display Rule_Transaltion once you build the relationship between two tables on Axis. However, it will always show "1" since each Rule_Name only appears one time.

Can you share some sample data?

Regards,