Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Here's an analogous example of what I'm doing:
I have a table of values with one row per customer which also has columns for the number of days they have been a customer as well as the date each of their companies was established. The table looks something like this:
Customer | Established Date | Days As Customer |
A | 2/15/2017 | 125 |
B | 5/12/2018 | 78 |
C | 6/3/2019 | 34 |
I want to create a column chart that has one column per Customer, sorted by their company's Established Date on the X-Axis, with the Days As Customer being the value per column. I can create a table of Customer vs Days As Customer just fine, but I need it to be sorted by Established Date on the X-Axis, which I can't seem to do. Is there a way to accomplish this?
Solved! Go to Solution.
@Anonymous you can sort your customer by established date, to do so, go to modelling tab, select Customer column and from menu, choose sort by column option and select established date to sort customer.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous you can sort your customer by established date, to do so, go to modelling tab, select Customer column and from menu, choose sort by column option and select established date to sort customer.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |