Forum Discussion

trijoco's avatar
trijoco
New Member
7 years ago
Solved

How to give variable values an alias?

Hi, I've been tasked with modifying an old Power BI report and was wondering if there's a way to give the values of a variable a different name, or alias, to make them easier to understand.   Speci...
Need Help
  • d_gosbell's avatar
    d_gosbell
    7 years ago
    trijoco wrote:

    Hi d_gosbell, thanks for the reply! Unfortunately I'm totally new to Power BI so I just wanted to confirm your instructions:

     

    1. Create JobStatuses table using the 'Enter Data' option in desktop app and follow that through

    2. Follow instructions in https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships to create a many to 1 relationship (I'm guessing the JobStatuses table just gives an alternate, worded value to JobStatus that is switched to)

    3. Replace instances of JobStatus with JobStatusDesc

     

    Again, I really appreciate the help, this seems easier than expected.

    Yes, that should be all you need to do.

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago

This is actually pretty easy. The best way to do this is to create a separate table (maybe called JobStatuses)

 

eg.

 

JobStatusJobStatusDesc
0Incomplete
10Processing
20Complete

 

Then create a many to 1 relationship between your existing JobStatus column and the JobStatus column in this new table

 

ExistingTable[JobStatus]  *  ---> 1   JobStatuses[JobStatus]

 

Then I would suggest hidding the existing [JobStatus] column and replacing anywhere that you used it with the new  JobStatuses[JobStatusDesc] column.

trijoco's avatar
trijoco
New Member
7 years ago

Hi d_gosbell, thanks for the reply! Unfortunately I'm totally new to Power BI so I just wanted to confirm your instructions:

 

1. Create JobStatuses table using the 'Enter Data' option in desktop app and follow that through

2. Follow instructions in https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships to create a many to 1 relationship (I'm guessing the JobStatuses table just gives an alternate, worded value to JobStatus that is switched to)

3. Replace instances of JobStatus with JobStatusDesc

 

Again, I really appreciate the help, this seems easier than expected.

  • d_gosbell's avatar
    d_gosbell
    Icon for Super User rankSuper User
    7 years ago
    trijoco wrote:

    Hi d_gosbell, thanks for the reply! Unfortunately I'm totally new to Power BI so I just wanted to confirm your instructions:

     

    1. Create JobStatuses table using the 'Enter Data' option in desktop app and follow that through

    2. Follow instructions in https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships to create a many to 1 relationship (I'm guessing the JobStatuses table just gives an alternate, worded value to JobStatus that is switched to)

    3. Replace instances of JobStatus with JobStatusDesc

     

    Again, I really appreciate the help, this seems easier than expected.

    Yes, that should be all you need to do.