Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear All,
I am a beginner in Power BI. I have a requirement to create a line chart with multiple Y axis as below. Also please note that the the X axis values have to come in the descending order. Kindly help.
Thanks in advance!!
Solved! Go to Solution.
If you click the ... menu that appears in the top right corner of the visual you will see the sort options where you can choose Ascending.
Hi Dear, I cannot see the sort option in the menu option.
Where are you X Values coming from? Do you have a date tabble
I think you may have found a BUG with the new Sort Capability they recently rolled out. I have to try to find an old powerbi install to test it.
When you have an integer series on the axis it does not let you sort! Also would not sort with Date[Date] on the axis I even tried specifying Sort by and choosing the date field. It did work with a text column in the date table that had Sort By used to specify the sort (in this case sort by [Date] column.
As a work around I added a "Last N Days" from NOW to my date table, added a second column for [Last N Days TXT] using FORMAT([Last N Days,"General Number") and set a visual filter on that to limit chart to last 21 days and the used the actual date on the axis. Could then sort just fine.
See this sample PBIX I modified form another solution I recently helped out on as an example.
Thank You So Much Seward. It works!!!
Regards,
Shahin K
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |