<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Broken x-axis sort order in combo chart in Get Started Discussions</title>
    <link>https://community.databricks.com/t5/get-started-discussions/broken-x-axis-sort-order-in-combo-chart/m-p/168401#M12103</link>
    <description>&lt;P&gt;Hello.&amp;nbsp; I am using the Combo Chart to create a Pareto visual.&amp;nbsp; I have an SQL query with built-in ordering, with output like:&lt;/P&gt;&lt;TABLE border="1" width="100%"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="12.5%" height="31px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="12.5%" height="31px"&gt;category&lt;/TD&gt;&lt;TD width="25%" height="31px"&gt;sort_order&lt;/TD&gt;&lt;TD width="25%" height="31px"&gt;category_count&lt;/TD&gt;&lt;TD width="25%" height="31px"&gt;cumulative_pct&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;1&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;SQL&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;1&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;52&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;29.9&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;2&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;Python&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;2&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;39&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;22.4&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;3&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;R&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;3&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;21&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;12.1&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;4&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;.Net&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;4&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;16&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;9.2&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;5&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;Bash&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;5&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;8&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;4.6&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;6&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;All Others&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;6&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;38&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;21.8&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;That's not the whole dataset, of course.&amp;nbsp; It's more complicated, but that's idea.&amp;nbsp; I'd be happy to post the script if it would help.&amp;nbsp; Anyway, I created (or, really, Genie created) a combo chart based on the data.&amp;nbsp; It worked, and the chart displayed in the same order on the x-axis as the sort_order in the data.&amp;nbsp; I liked it, but realized I needed to modify it a little.&amp;nbsp; That was successful, but the sorting is now ruined.&amp;nbsp; I didn't intentionally apply a sort, now it goes by 'category' alphabetical order.&lt;/P&gt;&lt;P&gt;So, at some point, it's as though the visualization editor applied no sort at all... it just went by the SQL order.&amp;nbsp; Now it does apply a sort order.&amp;nbsp; FWIW, the editor does currently have an alphabetical ordering applied:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="treesloth_0-1789152950131.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/31028i30E74307F0B0332B/image-size/medium?v=v2&amp;amp;px=400" role="button" title="treesloth_0-1789152950131.png" alt="treesloth_0-1789152950131.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;So, it's like I need to somehow tell it to use no ordering at all.&amp;nbsp; Maybe.&amp;nbsp; Or maybe it doesn't work like that at all.&amp;nbsp; But how do I get it to use sort_order again like it did before?&amp;nbsp; Or is something else going on here that I don't understand?&lt;/P&gt;</description>
    <pubDate>Fri, 11 Sep 2026 18:57:32 GMT</pubDate>
    <dc:creator>treesloth</dc:creator>
    <dc:date>2026-09-11T18:57:32Z</dc:date>
    <item>
      <title>Broken x-axis sort order in combo chart</title>
      <link>https://community.databricks.com/t5/get-started-discussions/broken-x-axis-sort-order-in-combo-chart/m-p/168401#M12103</link>
      <description>&lt;P&gt;Hello.&amp;nbsp; I am using the Combo Chart to create a Pareto visual.&amp;nbsp; I have an SQL query with built-in ordering, with output like:&lt;/P&gt;&lt;TABLE border="1" width="100%"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="12.5%" height="31px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="12.5%" height="31px"&gt;category&lt;/TD&gt;&lt;TD width="25%" height="31px"&gt;sort_order&lt;/TD&gt;&lt;TD width="25%" height="31px"&gt;category_count&lt;/TD&gt;&lt;TD width="25%" height="31px"&gt;cumulative_pct&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;1&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;SQL&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;1&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;52&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;29.9&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;2&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;Python&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;2&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;39&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;22.4&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;3&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;R&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;3&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;21&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;12.1&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;4&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;.Net&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;4&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;16&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;9.2&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;5&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;Bash&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;5&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;8&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;4.6&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="12.5%" height="30px"&gt;6&lt;/TD&gt;&lt;TD width="12.5%" height="30px"&gt;All Others&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;6&lt;/TD&gt;&lt;TD width="25%" height="30px"&gt;38&lt;/TD&gt;&lt;TD width="25%" height="20"&gt;21.8&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;That's not the whole dataset, of course.&amp;nbsp; It's more complicated, but that's idea.&amp;nbsp; I'd be happy to post the script if it would help.&amp;nbsp; Anyway, I created (or, really, Genie created) a combo chart based on the data.&amp;nbsp; It worked, and the chart displayed in the same order on the x-axis as the sort_order in the data.&amp;nbsp; I liked it, but realized I needed to modify it a little.&amp;nbsp; That was successful, but the sorting is now ruined.&amp;nbsp; I didn't intentionally apply a sort, now it goes by 'category' alphabetical order.&lt;/P&gt;&lt;P&gt;So, at some point, it's as though the visualization editor applied no sort at all... it just went by the SQL order.&amp;nbsp; Now it does apply a sort order.&amp;nbsp; FWIW, the editor does currently have an alphabetical ordering applied:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="treesloth_0-1789152950131.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/31028i30E74307F0B0332B/image-size/medium?v=v2&amp;amp;px=400" role="button" title="treesloth_0-1789152950131.png" alt="treesloth_0-1789152950131.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;So, it's like I need to somehow tell it to use no ordering at all.&amp;nbsp; Maybe.&amp;nbsp; Or maybe it doesn't work like that at all.&amp;nbsp; But how do I get it to use sort_order again like it did before?&amp;nbsp; Or is something else going on here that I don't understand?&lt;/P&gt;</description>
      <pubDate>Fri, 11 Sep 2026 18:57:32 GMT</pubDate>
      <guid>https://community.databricks.com/t5/get-started-discussions/broken-x-axis-sort-order-in-combo-chart/m-p/168401#M12103</guid>
      <dc:creator>treesloth</dc:creator>
      <dc:date>2026-09-11T18:57:32Z</dc:date>
    </item>
    <item>
      <title>Re: Broken x-axis sort order in combo chart</title>
      <link>https://community.databricks.com/t5/get-started-discussions/broken-x-axis-sort-order-in-combo-chart/m-p/168455#M12108</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/249585"&gt;@treesloth&lt;/a&gt;,&lt;/P&gt;
&lt;DIV data-genai-markdown-block="true"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV data-genai-markdown-block="true"&gt;The combo chart visualisation does not support "By field" sorting on the x-axis. If you open the x-axis kebab menu, you'll see that the "By field" option is greyed out with a "Not available for this visualisation" tooltip. This means you can't point the x-axis sort at your&amp;nbsp;sort_order&amp;nbsp;column the way you could with a regular bar chart. The only sort options available for combo charts are&amp;nbsp;Alphabetical&amp;nbsp;and&amp;nbsp;Custom.&lt;/DIV&gt;
&lt;DIV data-genai-markdown-block="true"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV data-genai-markdown-block="true"&gt;I reproduced this in my own workspace using a simplified version of your dataset to confirm the behaviour. Here's what I found.&lt;/DIV&gt;
&lt;DIV data-genai-markdown-block="true"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV data-genai-markdown-block="true"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="orderbyField.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/31046iFB86CD3955044CF2/image-size/medium?v=v2&amp;amp;px=400" role="button" title="orderbyField.png" alt="orderbyField.png" /&gt;&lt;/span&gt;&lt;/DIV&gt;
&lt;DIV data-genai-markdown-block="true"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV data-genai-markdown-block="true"&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;When Genie first created the chart, it likely set up the visualisation without an explicit sort, so the chart reflected your SQL row order. The moment you edited the widget in the visual editor, the editor took ownership of the sort configuration and applied its default, which is alphabetical. That's why it broke after your edit, even though you didn't intentionally change the sort.&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;Here are a couple of workarounds you can try.&amp;nbsp;&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;&lt;STRONG&gt;Option 1: Custom sort (quick fix):&amp;nbsp;&lt;/STRONG&gt;Open the x-axis kebab menu, choose Custom under Sort, and drag the category values into your Pareto order: SQL, Python, R, .Net, Bash, All Others. This works perfectly, but is manual. If your underlying data changes and new categories appear, you'll need to re-drag them into position.&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ashwin_DSA_0-1789298164091.png" style="width: 999px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/31047iF6E3089D780A14F3/image-size/large?v=v2&amp;amp;px=999" role="button" title="Ashwin_DSA_0-1789298164091.png" alt="Ashwin_DSA_0-1789298164091.png" /&gt;&lt;/span&gt;&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;&lt;STRONG&gt;Option 2: SQL prefix trick (automatic fix)&lt;/STRONG&gt;&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;If your data changes frequently and you don't want to manually reorder every time, you can prepend the sort order to the category name directly in your SQL. Something like:&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;&lt;LI-CODE lang="python"&gt;SELECT 
  CONCAT(LPAD(CAST(sort_order AS STRING), 2, '0'), '. ', category) AS category, 
  sort_order, 
  category_count, 
  cumulative_pct
FROM (
  -- your original query here
)
ORDER BY sort_order&lt;/LI-CODE&gt;&lt;/DIV&gt;
&lt;DIV data-genai-markdown-block="true"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV data-genai-markdown-block="true"&gt;This turns your categories into&amp;nbsp;01. SQL,&amp;nbsp;02. Python,&amp;nbsp;03. R, and so on. Since the editor's alphabetical sort now sorts&amp;nbsp;01...&amp;nbsp;before&amp;nbsp;02..., the Pareto order is preserved automatically. The tradeoff is that your x-axis labels will have the numeric prefix, which isn't as clean, but it's fully hands-off when data changes.&lt;/DIV&gt;
&lt;DIV data-genai-markdown-block="true"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ashwin_DSA_1-1789298335209.png" style="width: 999px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/31048i507C684B07CFE7F2/image-size/large?v=v2&amp;amp;px=999" role="button" title="Ashwin_DSA_1-1789298335209.png" alt="Ashwin_DSA_1-1789298335209.png" /&gt;&lt;/span&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;If your categories are fairly stable, go with&amp;nbsp;Custom sort. It gives you clean labels and exact control. If your query is dynamic and categories shift over time, the&amp;nbsp;SQL prefix&amp;nbsp;approach saves you from having to re-drag things every time you refresh.&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;Hope that helps! Let us know if you run into anything else.&lt;/DIV&gt;
&lt;DIV class="du-bois-light-typography css-zj8sjw" data-genai-markdown-block="true"&gt;
&lt;P class="p1"&gt;&lt;FONT size="2" color="#FF6600"&gt;&lt;STRONG&gt;&lt;I&gt;If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.&lt;/I&gt;&lt;/STRONG&gt;&lt;/FONT&gt;&lt;I&gt;&lt;/I&gt;&lt;/P&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;</description>
      <pubDate>Sun, 13 Sep 2026 11:20:18 GMT</pubDate>
      <guid>https://community.databricks.com/t5/get-started-discussions/broken-x-axis-sort-order-in-combo-chart/m-p/168455#M12108</guid>
      <dc:creator>Ashwin_DSA</dc:creator>
      <dc:date>2026-09-13T11:20:18Z</dc:date>
    </item>
    <item>
      <title>Re: Broken x-axis sort order in combo chart</title>
      <link>https://community.databricks.com/t5/get-started-discussions/broken-x-axis-sort-order-in-combo-chart/m-p/168527#M12112</link>
      <description>&lt;P&gt;Thank you.&amp;nbsp; I appreciate the detailed response.&amp;nbsp; I'd already done the second option as what I hoped would be a temporary workaround.&amp;nbsp; Sadly, the categories are far from stable, and orders can switch (although that's not quite as common).&amp;nbsp; But, at least now I know I'm not crazy (or, at least, that this is not what proves it).&amp;nbsp; Thank you.&lt;/P&gt;</description>
      <pubDate>Mon, 14 Sep 2026 13:06:24 GMT</pubDate>
      <guid>https://community.databricks.com/t5/get-started-discussions/broken-x-axis-sort-order-in-combo-chart/m-p/168527#M12112</guid>
      <dc:creator>treesloth</dc:creator>
      <dc:date>2026-09-14T13:06:24Z</dc:date>
    </item>
  </channel>
</rss>

