Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
GAPER
Post Patron
Post Patron

Change the Label to text (from year)

GAPER_0-1721699567557.png

Currently the last value (2050) is an average of all the previous years. I did a hack by creating additional roles in the data base where year is 2050. However, I would like to make the 2050 to "overall" but overall is not a number which messed up my x axis ordering. Is there a way i can change it to "Overall" while the y axis know how to sort it in asecnding manner and the "Overall" always appearing to the far right end? 

1 ACCEPTED SOLUTION

In your data set you have a column with all of the Year numbers. Its the column you put into this graph to be one of your Axis.

Create a new dax column with the logic of

 

IF([YearColumn] = 2050, "Overall", [YearColumn]

 

(Where [YearColumn] is replaced with the name of your actual column containing year values.

 

After creating this column, make sure its selected and look for a menu called "Column Tools". There is an option in there called "Sort By Column", click on that and select the YearColumn.

 

Put this new column on your graph axis instead.

View solution in original post

3 REPLIES 3
GAPER
Post Patron
Post Patron

Sorry I don't seem to understand

 

In your data set you have a column with all of the Year numbers. Its the column you put into this graph to be one of your Axis.

Create a new dax column with the logic of

 

IF([YearColumn] = 2050, "Overall", [YearColumn]

 

(Where [YearColumn] is replaced with the name of your actual column containing year values.

 

After creating this column, make sure its selected and look for a menu called "Column Tools". There is an option in there called "Sort By Column", click on that and select the YearColumn.

 

Put this new column on your graph axis instead.

RossEdwards
Solution Sage
Solution Sage

Yes!  In the same table as your years, create a new column which is text and all of the year values are the same, except make the 2050 text value say "Overall".  With that column created, use the column tools to tell it to "Sort By" and select the years column.  This will put Overall at the end.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.