Select to view content in your preferred language

ARCGIS Visual does not recognize PowerBI table sorting

214
0
01-01-2025 08:18 AM
RodPBI
by
Regular Contributor

A common method in Power BI to display a legend in the proper order is to use a sort column as defined in Table View in a related legend table.   For instance, if I want to display a condition legend from "VERY POOR" to "VERY GOOD" I use numeric values in my sort column to define how to sort the text values I want to display:

TEXT           SORT VALUE
POOR                       2
VERY POOR            1
VERY GOOD           5
GOOD                      4
FAIR                          3

When Sorted in Table View:
TEXT           SORT VALUE
VERY POOR            1
POOR                       2
FAIR                          3
GOOD                      4
VERY GOOD           5

And the end result can be illustrated in most any Visual in Power BI
such as a table....

RodPBI_0-1735747194684.png

....or the Azure Map Visual:

RodPBI_1-1735747259143.png

The problem is that the ARCGIS Visual does not recognize this pre-defined sort order even though I'm pulling the same data I'm using in the Azure map visual. Here's a screen shot from the ArcGIS Visual legend:

RodPBI_3-1735748055795.png

Please make it so the ArcGIS visual recognizes the sort order as defined in Table View -OR- if there is another way to display the legend in the order desired, please tell me how!

 

 

Tags (1)
0 Kudos
0 Replies