renaming the content in the column only for visual

[Rohiniv25]

I have a coloumn named grouping as Bi, 1st , 2nd while showing that in visuals wanted to rename those as Bi lateral , 1st pary ad so on, as these all sit under the same heading in the table not able to rename those for the visuals.

Can you please help on this

[Rohiniv25]

Thank you. 

I have one more doubt, if we have group few KPI under one head under the table can we arrange them according to the visuals that is required for us 

if the group shows 2nd party first then the corp then the 1st , I need to arrange them in 1st, 2nd and corp order in a table visualization.

[Deku]

Finding it hard to understand the question, can you show a example of the problem and a example of the expected outcome

[Rohiniv25]

all these are under sla wanted to rearrage this like sla in the first then the percentage not able to move as this is filtered from the SLA

[pankajnamekar25 · Accepted solution]

Hello @Rohiniv25 

Create calculated column 

Grouping Visual =
SWITCH(
TRUE(),
'YourTable'[Grouping] = "Bi", "Bilateral",
'YourTable'[Grouping] = "1st", "1st Party",
'YourTable'[Grouping] = "2nd", "2nd Party",
'YourTable'[Grouping]
)

us that on visual

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[Sonalika]

Rohiniv25 You can rename the values in columns for visualization using a calculated column .

Use a new column Grouping_New  instead of grouping.

Use can try the following DAX formula :
Grouping_New =   SWITCH( 'YourTable'[Grouping],
"Bi", "Bi lateral",
"1st", "1st party",
"2nd", "2nd party",
'YourTable'[Grouping] 
)
Hope this helps! 😊