Evaluate different column types - here formulas and text

I would like to evaluate values ​​from two boards in the dashboard. The x-axis is a text field in one board and a formula field in which text is also generated in the other.
Obviously in monday the column type for an x-axis must be identical, either both being a formula field or both being a text field.
How can I solve this?