Simple waterfall chart: Changing the label name

[Anuj_1196]

Hi Community,

How could I change the name of the label in the Simple Waterfall chart? I have brought the categories to drill down the visual. I don't wish to make the change in the category.

[rajendraongole1]

Hi @Anuj_1196  Since you're using drill-down functionality, You can create a new calculated column in your data model that replaces the original category name with a custom label.

create a calculated column

eg: Custom Category =
SWITCH(
TRUE(),
'Table'[Category] = "Old Category Name", "New Label Name",
'Table'[Category] -- Keep the rest unchanged
)

Replace the original Category field in your Axis section of the Waterfall chart with the new Custom Category column.

Hope this helps.