Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Editing data in your current data model

I have a table which holds payment types. The types are only abbreviated in my model as C(cash) and D(debit order). I want to change the data to actaully show Cash and Debit order. So that my visual...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You can add two new custom cloumns in the query edit.

    Then remove the "C" and "D" columns, click "Close & Apply".

    This method will not change the data in the DB and will not affect the next refresh.

     

MatejZukovic's avatar
MatejZukovic
Resolver I
6 years ago

Hi Anonymous ,

 

if you don't want to modify your source table you can create a mapping table with two columns - first with abbreviation and second with full description. 

 

Then you can create relationship between the two tables and use field containing full description in your dashboard.

 

Hope it helps!

Matej