So I have this stacked column chart:
Think the main issue here is that I have 2 fields on the x-axis.
So I have period and in this period type of volume (quantity in this case). Actual and LBE1.
In the legend I have the countries.
The chart is now sorted by country. But what we would like for this purpose is put the biggest chuck of every column at the bottom.
For Jan24 this would meen start with China for both Actual and LBE1.
But 2nd biggest for Actual would be India, however for LBE1 india is big with 50K but there is one bigger with 84K (russia) so that would come 2nd in LBE1.
Can this be done? Can we "rank" the volume by country in Type and Period but ofcourse keep the X-axis formatting.
Meaning Period Jan first and Actual comes before LBE1.
This chart is based on a sample test data which I will paste below so people can put that in Excel and use it to play around in PBI.
| Period | Type | Volume | Country |
| Jan-24 | Actual | 484 | Australia |
| Jan-24 | Actual | 3863 | Brazil |
| Jan-24 | Actual | 8 | Chile |
| Jan-24 | Actual | 85069 | China |
| Jan-24 | Actual | 2350 | Colombia |
| Jan-24 | Actual | 100 | Costa Rica |
| Jan-24 | Actual | 5 | Croatia |
| Jan-24 | Actual | 6012 | Czech Republic |
| Jan-24 | Actual | 40 | Ecuador |
| Jan-24 | Actual | 1840 | Egypt |
| Jan-24 | Actual | 1615 | Hong Kong |
| Jan-24 | Actual | 1828 | Hungary |
| Jan-24 | Actual | 49292 | India |
| Jan-24 | Actual | 1031 | Indonesia |
| Jan-24 | Actual | 2660 | Malaysia |
| Jan-24 | Actual | 979 | Mexico |
| Jan-24 | Actual | 9012 | Other |
| Jan-24 | Actual | 11060 | Pakistan |
| Jan-24 | Actual | 100 | Paraguay |
| Jan-24 | Actual | 71 | Peru |
| Jan-24 | Actual | 528 | Philippines |
| Jan-24 | Actual | 3185 | Romania |
| Jan-24 | Actual | 27825 | Russian Fed. |
| Jan-24 | Actual | 1890 | Serbia |
| Jan-24 | Actual | 1006 | Singapore |
| Jan-24 | Actual | 6 | South Africa |
| Jan-24 | Actual | 15707 | South Korea |
| Jan-24 | Actual | 5119 | Taiwan |
| Jan-24 | Actual | 4498 | Thailand |
| Jan-24 | Actual | 12946 | Turkey |
| Jan-24 | Actual | 1398 | Ukraine |
| Jan-24 | Actual | 3 | Utd.Arab Emir. |
| Jan-24 | Actual | 2310 | Vietnam |
| Jan-24 | LBE1 | 52942 | |
| Jan-24 | LBE1 | 9246 | Brazil |
| Jan-24 | LBE1 | 85815 | China |
| Jan-24 | LBE1 | 1745 | Colombia |
| Jan-24 | LBE1 | 853 | Hong Kong |
| Jan-24 | LBE1 | 50459 | India |
| Jan-24 | LBE1 | 3023 | Indonesia |
| Jan-24 | LBE1 | 1364 | Malaysia |
| Jan-24 | LBE1 | 1162 | Mexico |
| Jan-24 | LBE1 | 89 | Oceana |
| Jan-24 | LBE1 | 397 | Philippines |
| Jan-24 | LBE1 | 84106 | Russian Fed. |
| Jan-24 | LBE1 | 374 | Singapore |
| Jan-24 | LBE1 | 9977 | South Korea |
| Jan-24 | LBE1 | 2790 | Taiwan |
| Jan-24 | LBE1 | 3513 | Thailand |
| Jan-24 | LBE1 | 24794 | Turkey |
| Feb-24 | Actual | 327 | Argentina |
| Feb-24 | Actual | 11 | Australia |
| Feb-24 | Actual | 6941 | Brazil |
| Feb-24 | Actual | 31 | Chile |
| Feb-24 | Actual | 86572 | China |
| Feb-24 | Actual | 1931 | Colombia |
| Feb-24 | Actual | 82 | Costa Rica |
| Feb-24 | Actual | 45 | Croatia |
| Feb-24 | Actual | 4270 | Czech Republic |
| Feb-24 | Actual | 12 | Egypt |
| Feb-24 | Actual | 1292 | Hong Kong |
| Feb-24 | Actual | 1606 | Hungary |
| Feb-24 | Actual | 50481 | India |
| Feb-24 | Actual | 4043 | Indonesia |
| Feb-24 | Actual | 70 | Israel |
| Feb-24 | Actual | 1282 | Malaysia |
| Feb-24 | Actual | 796 | Mexico |
| Feb-24 | Actual | 14523 | Other |
| Feb-24 | Actual | 7100 | Pakistan |
| Feb-24 | Actual | 49 | Paraguay |
| Feb-24 | Actual | 38 | Peru |
| Feb-24 | Actual | 1023 | Philippines |
| Feb-24 | Actual | 4219 | Romania |
| Feb-24 | Actual | 36516 | Russian Fed. |
| Feb-24 | Actual | 2528 | Serbia |
| Feb-24 | Actual | 588 | Singapore |
| Feb-24 | Actual | 1421 | South Africa |
| Feb-24 | Actual | 15409 | South Korea |
| Feb-24 | Actual | 3207 | Taiwan |
| Feb-24 | Actual | 5346 | Thailand |
| Feb-24 | Actual | 8136 | Turkey |
| Feb-24 | Actual | 8534 | Ukraine |
| Feb-24 | Actual | 1147 | Uruguay |
| Feb-24 | Actual | 46 | Venezuela |
| Feb-24 | Actual | 2135 | Vietnam |
| Feb-24 | LBE1 | 45926 | |
| Feb-24 | LBE1 | 11532 | Brazil |
| Feb-24 | LBE1 | 79834 | China |
| Feb-24 | LBE1 | 1986 | Colombia |
| Feb-24 | LBE1 | 1224 | Hong Kong |
| Feb-24 | LBE1 | 50488 | India |
| Feb-24 | LBE1 | 3556 | Indonesia |
| Feb-24 | LBE1 | 1136 | Malaysia |
| Feb-24 | LBE1 | 1852 | Mexico |
| Feb-24 | LBE1 | 95 | Oceana |
| Feb-24 | LBE1 | 392 | Philippines |
| Feb-24 | LBE1 | 34821 | Russian Fed. |
| Feb-24 | LBE1 | 508 | Singapore |
| Feb-24 | LBE1 | 9708 | South Korea |
| Feb-24 | LBE1 | 4572 | Taiwan |
| Feb-24 | LBE1 | 4297 | Thailand |
| Feb-24 | LBE1 | 30000 | Turkey |
| Mar-24 | Actual | 350 | Algeria |
| Mar-24 | Actual | 552 | Argentina |
| Mar-24 | Actual | 1107 | Australia |
| Mar-24 | Actual | 8304 | Brazil |
| Mar-24 | Actual | 23 | Chile |
| Mar-24 | Actual | 65850 | China |
| Mar-24 | Actual | 1849 | Colombia |
| Mar-24 | Actual | 68 | Costa Rica |
| Mar-24 | Actual | 3099 | Czech Republic |
| Mar-24 | Actual | 108 | Ecuador |
| Mar-24 | Actual | 3080 | Egypt |
| Mar-24 | Actual | 1309 | Hong Kong |
| Mar-24 | Actual | 2472 | Hungary |
| Mar-24 | Actual | 67397 | India |
| Mar-24 | Actual | 4722 | Indonesia |
| Mar-24 | Actual | 2095 | Malaysia |
| Mar-24 | Actual | 313 | Mexico |
| Mar-24 | Actual | 12656 | Other |
| Mar-24 | Actual | 24722 | Pakistan |
| Mar-24 | Actual | 102 | Peru |
| Mar-24 | Actual | 296 | Philippines |
| Mar-24 | Actual | 2102 | Romania |
| Mar-24 | Actual | 37000 | Russian Fed. |
| Mar-24 | Actual | 543 | Singapore |
| Mar-24 | Actual | 422 | South Africa |
| Mar-24 | Actual | 1983 | South Korea |
| Mar-24 | Actual | 2985 | Taiwan |
| Mar-24 | Actual | 4595 | Thailand |
| Mar-24 | Actual | 10943 | Turkey |
| Mar-24 | Actual | 364 | Ukraine |
| Mar-24 | Actual | 706 | Uruguay |
| Mar-24 | Actual | 35 | Utd.Arab Emir. |
| Mar-24 | Actual | 2431 | Vietnam |
| Mar-24 | LBE1 | 52824 | |
| Mar-24 | LBE1 | 5928 | Brazil |
| Mar-24 | LBE1 | 71103 | China |
| Mar-24 | LBE1 | 2020 | Colombia |
| Mar-24 | LBE1 | 847 | Hong Kong |
| Mar-24 | LBE1 | 95981 | India |
| Mar-24 | LBE1 | 2657 | Indonesia |
| Mar-24 | LBE1 | 1860 | Malaysia |
| Mar-24 | LBE1 | 856 | Mexico |
| Mar-24 | LBE1 | 121 | Oceana |
| Mar-24 | LBE1 | 403 | Philippines |
| Mar-24 | LBE1 | 31413 | Russian Fed. |
| Mar-24 | LBE1 | 461 | Singapore |
| Mar-24 | LBE1 | 2088 | South Korea |
| Mar-24 | LBE1 | 2752 | Taiwan |
| Mar-24 | LBE1 | 4148 | Thailand |
| Mar-24 | LBE1 | 31138 | Turkey |
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
