Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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?
Solved! Go to 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.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |