Color all distinct values differently

[Jan123]

I want each distinct value in the list to have a different color so I can distinguish them.

[v-juanli-msft]

Hi @Jan123

Which visual do you want this to display on?

If there are not too many distinct values in the list, you could add this column(contains these distinct values) to the Legend Field in the column chart or line chart.

Or you could use "conditional formatting" in the Table or Matrix visual.

Best Regards

Maggie