Data color in table or matrix

SysLostInBI While you can't adjust the legend on a visual, you can try to match that matrix to match it.

I have data by US state names, and when I put that on a line chart, it defaults the legend to be alphabetical and the colors run through default colors. 

1. In transform data: I created a dimension table for the states, by duplicating the data table, choosing only the states column, removing duplicates, sorting it alphabetical, then added an Index Column. The goal is to get 0-49 for each of the state names starting with Alabama. It's great to that here so that if say a new state does get added, it will just add it automatically.

2. After applying those changes, I create a relationship to that dimension table on the state name. and change where i used that state name in my visuals to use the new dimension table version.

3. I then created a measure to get me the that index. 

Index Measure = min(Category[Index])

 

4. Then I created a conditional format on the matrix conditional formatting for background color (or font color, whatever you want) and you you set it up to be based on that "Index Measure" and simply choose the default colors would be starting with 0:

 

 

Just go across the top in the default colors, then 2nd row, etc. Mine also had some greens, so I just went and got it from the data colors that defaulted in on the line chart.

 

The end result is now the matrix will copy the default legend of the line chart.