Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Replace Values in Power BI for display purposes .. not backend data source -

I have a column name "Team" with several values:

 

USIT Domain 1

USIT Domain 2 .. etc.

 

My customer asked me to change the names to the following for a PBI report:

 

Domain 1,

Domain 2 ..etc.

 

I do not want to change the backend data source , just the values in the Power BI table . .is this possible? I've tried to  do "Replace Values" but it does not work and removes my data .from the report.

 

Thank you.

1 ACCEPTED SOLUTION

If you want to remove the first 4 alphabets then use the below formula as a calculated column.

RenamedTeam= right(Company[team],len(Company[team])-5)

Regards,

Atma.

View solution in original post

6 REPLIES 6
mahenkj2
Impactful Individual
Impactful Individual

Hi @Anonymous ,

 

Can you please post an example how replace value does not work. Even if it does not work, we can tweak further few things as may be needed. Pls try to give more detail, some sample data and scenario where it does not work would be much helpful.

 

Hope it helps.

tamerj1
Super User
Super User

@Anonymous 

This possible only if you are not slicing by this column. You can use measure for example:

MID (

SELECTEDVALUE ( TableName[ColumnName] ),

8,

LEN ( SELECTEDVALUE ( TableName[ColumnName] ) - 8 

)

normally you should use variables to avoid multiple evaluations of the same expression 

Anonymous
Not applicable

Thank you for replying.  Can you give me the example using one of my values:

 

Table: Company

Column: Team

Current Value: USIT Domain 1

New Value: Domain 1

 

I see your selected statement but do not know the syntax for the value change?

 

Much appreciated!

@Anonymous 
I have no idea why I used "8". However, you can use the following
1.png

If you want to remove the first 4 alphabets then use the below formula as a calculated column.

RenamedTeam= right(Company[team],len(Company[team])-5)

Regards,

Atma.

Hi @Anonymous  sorry to disturb you, If you find this as a solution can you mark the reply as a solution,

Regards,

Atma.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors