Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@vitexo87 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |