Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Simple waterfall chart: Changing the label name

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.

 

 

Need Help

1 Reply

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous  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.