range in axis

Don't @Vickram

From the @Pragati11 and amitchandak, they show you how to achieve your goal using a calculated column or measure.

And you can test my way of creating a custom column in Power Query.

Sample table:

Custom column:

Flag
=
if 
[Age]>=0 and [Age]<=4 then "0-4" 
else if 
[Age]>=5 and [Age]<=11 then "5-11"
else if
[Age]>=12 and [Age]<=17 then "12-17"
else if
[Age]>=18 and [Age]<=24 then "18-24"
else if
[Age]>=25 and [Age]<=34 then "25-34"
else if
[Age]>=35 and [Age]<=49 then "35-49"
else if
[Age]>=50 and [Age]<=59 then "50-59"
else if
[Age]>=60 and [Age]<=69 then "60-69"
else if
[Age]>=70 and [Age]<=84 then "70-84"
else "85+"

Next, we group all rows by brand column.

Add an Index column to sort the marks.

Finally, expand All Rows.

Remove the First Indicator column and rename other columns. The result is as follows.

My M query is as follows.

let
    Source = Excel.Workbook(File.Contents("C:\Users\ricoz\Desktop\New Microsoft Excel Worksheet.xlsx"), null, true),
    Sheet27_Sheet = Source{[Item="Sheet27",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet27_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Year", Int64.Type}, {"Age", Int64.Type}, {"Population", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Flag", each if 
[Age]>=0 and [Age]<=4 then "0-4" 
else if 
[Age]>=5 and [Age]<=11 then "5-11"
else if
[Age]>=12 and [Age]<=17 then "12-17"
else if
[Age]>=18 and [Age]<=24 then "18-24"
else if
[Age]>=25 and [Age]<=34 then "25-34"
else if
[Age]>=35 and [Age]<=49 then "35-49"
else if
[Age]>=50 and [Age]<=59 then "50-59"
else if
[Age]>=60 and [Age]<=69 then "60-69"
else if
[Age]>=70 and [Age]<=84 then "70-84"
else "85+"),
    #"Grouped Rows" = Table.Group(#"Added Custom", {"Flag"}, {{"All Row", each _, type table [Year=nullable number, Age=nullable number, Population=nullable number, Flag=text]}}),
    #"Added Index" = Table.AddIndexColumn(#"Grouped Rows", "Index", 1, 1, Int64.Type),
    #"Expanded All Row" = Table.ExpandTableColumn(#"Added Index", "All Row", {"Year", "Age", "Population", "Flag"}, {"All Row.Year", "All Row.Age", "All Row.Population", "All Row.Flag"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded All Row",{"Flag"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"All Row.Year", "Year"}, {"All Row.Age", "Age"}, {"All Row.Population", "Population"}, {"All Row.Flag", "Flag"}})
in
    #"Renamed Columns"

You can download my pbix file from this link: range on the axis

Best regards

Rico Zhou

If this post helps,then consider Accepting it as the solution to help other members find it faster.