Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everybody!
I am currently trying to sort the data on my graph (on the x-axis) in a certain way but it doesn't seem to work.
Currently my graphs show data like this (x-axis):
01, 02, 03, ..., 12, CF02, CY17, Target
But I want them do be displayed in this order:
CY17, 01, 02, ..., 12, Target, CF02
So I created a new table, assigned a number to each value and created a relationship to my basedata. Then I used "related" function in my basedata to assign the numbers to the respective entry.
However, this is what BI does:
Can somebody tell me why it doesn't work? I looked this approach up on the internet and it should work like this...
Thank you for your help!
Solved! Go to Solution.
Hi @Landmann,
May be you could try this way without creating a new table. By the steps below you could get your expected order.
1. Go to Query Editor, add a conditional column.
2. Apply && Close. Go to Data View and select column1 sort by custom column, then you could create the visual.
Hope this can help you!
Best Regards,
Cherry
Hi @Landmann,
May be you could try this way without creating a new table. By the steps below you could get your expected order.
1. Go to Query Editor, add a conditional column.
2. Apply && Close. Go to Data View and select column1 sort by custom column, then you could create the visual.
Hope this can help you!
Best Regards,
Cherry