Set specific colours for legend

[Anonymous]

Hello,

I have the following table with legend showing a different colour for every distinct Document ID. Is it possible to choose or set a specific colour for each Document ID? The problem is that when the dashboard is refreshed, the legend colours change for the Document ID. If this is not supported natively in Power BI, maybe there is an additional visualization for this?

Document ID	Validity	Credit
3998	01/01/2018	2200
4050	01/01/2020	8170
4050	18/05/2020	4171
4060	11/01/2020	6688
4139	12/08/2020	7841
4145	01/01/2020	3897
4149	01/01/2020	9117
4157	25/11/2019	7891
4160	01/01/2020	4894
4160	08/04/2020	1171
4164	01/01/2020	3991
4166	01/01/2020	220
4187	01/01/2020	2200
4187	07/12/2022	720
4187	17/12/2023	154
4187	19/12/2022	5458

[Greg_Deckler · Accepted solution]

@Anonymous