How to add synonyms to values in column for Q&A visual

[krishb1414]

Hi Everyone,

Is it possible to add synonyms to values in a column. As Power bi supports adding synonyms to column names, table names. 

Kindly request for quick response, Thanks

[rajendraongole1]

Hi @krishb1414 -Power BI does not directly support adding synonyms to column values but another way somehting like , You can create a reference table that maps each value to its synonyms to your data values.Establish a relationship between your main data table and the synonym table based on the value column.

Hope it helps.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[krishb1414]

Hi @rajendraongole1 , Thanks for your suggestion. 

So, you mean if i need to add 3 synonyms then i need to create 3 columns and then create a relationship with the main table. Is it correct ?