The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
it is possible to rename the column name only in a chart object?
Solved! Go to Solution.
The short answer is no. There is one model that applies to all visuals. I suggest you to work your Semantic Layer and avoid duplicating columns unnecessarily whenever possible.
However, you could rename certain servers certain ways vs other to hide their identities by using DAX to create a new column as suggested but with IF statements.
Something similar will do the trick:
Friendly Server Name = IF([Server Name]= "Server", "Server 1", [Server Name] )
Thanks,
Fahd
You can create an "identity" calculated column with the desired name, for example-
NewColumnName = [OldColumnName]
and use the new column in your chart instead of the old one.
could you give an example with my data? because I used his example here and did not work:
Table: Fact
column: Server
new name: Server1
The short answer is no. There is one model that applies to all visuals. I suggest you to work your Semantic Layer and avoid duplicating columns unnecessarily whenever possible.
However, you could rename certain servers certain ways vs other to hide their identities by using DAX to create a new column as suggested but with IF statements.
Something similar will do the trick:
Friendly Server Name = IF([Server Name]= "Server", "Server 1", [Server Name] )
Thanks,
Fahd
@Anonymous The change would need to be done in your model. Based on the above suggestion you would go to the table that contains column: Server and right click on the table - "Add Column" and type in the DAX function listed above. In your case
Server1 = [Server]
Then, in the visual, you would use the new column.
There is no way to change the field names in visuals, so you either need to change the column name in the table, or create a little bloat in your model by adding a duplicate column as described.
I believe no.