Forum Discussion

alvin199's avatar
alvin199
Helper III
4 years ago
Solved

Rename Axis from Auto Label

I am grouping the age using Data Groups function in Power BI. In its setting, I have selected Size of bins and Power BI auto detected the minimum and maximum values of the age column are 19 and 50 respectively. So, it will decide the number of group.

 

I have the output in the bar chart below. My question is how can I rename the X-axis. For example the first bar is name as 1-19, second bar is 20-29, and etc. 

 

Need Help
  • KNP's avatar
    KNP
    4 years ago

    Something like this as a new column...

    Age Range = 
    SWITCH(
        TRUE(),
        'Table'[Age] < 19, "0 - 19",
        'Table'[Age] < 39, "20 - 39",
        'Table'[Age] < 59, "40 - 59",
        "60+"
        )

    Substitute your table name and column name.

     

2 Replies

  • KNP's avatar
    KNP
    Super User
    4 years ago

    It might be possible to create a custom label for the axis as a new column based on the bin values, but, to be honest, it is probably easier to just control the grouping yourself. This could be done in Power Query or DAX depending on your preference.

    This is a good article to explain one way to approach it...

    https://radacad.com/create-customized-age-bins-or-groups-in-power-bi

    There are a number of links in there showing how to make it controllable with measures also.

     

    • KNP's avatar
      KNP
      Super User
      4 years ago

      Something like this as a new column...

      Age Range = 
    SWITCH(
        TRUE(),
        'Table'[Age] < 19, "0 - 19",
        'Table'[Age] < 39, "20 - 39",
        'Table'[Age] < 59, "40 - 59",
        "60+"
        )

      Substitute your table name and column name.