Change Data Bar name in visualization

Anonymous

You can create a new column where you will change the values to the ones you want and then add this column to the graph.

New_Column = 
SUBSTITUTE (
  SUBSTITUTE (
    SUBSTITUTE (
        SUBSTITUTE ( 'Table'[Column1], "Num1", "State-1" ),
        "Num2",
        "State-2"
    ),
    "Num3",
    "State-3"
  ),"Num4",
    "State-4"
)

Hi Anonymous,

You can use switch statement for this.....

NewColuimn =  SWITCH(Table[Column] ,

                                        "Num1","State-1",

                                         "Num2","State-2",

                                         "Num3","State-3","Table[Column]")

Or you can use if statement.

Best Regards,

Ravi