Don't want to change the legend color in date category in bar chart of tree chart in Power BI

[bezawak]

When there is change in the data the colors of the legend in the date category changes automatically for bar chart or tree chart 

is there a way to over ride data category color and keep it same as even the back end data changes :

Examaple : Bar Chart --We have bins like bin1 0 -5 days ,bin2 5 -10 ( We have one color for each bin )

Now when we change the bin to bin1 :0-10 bin 2 :10-15 the color of the previuous bins defined will go away is there a way to keep the color same even thought when we change the bins ...this is typical bussiness requirmet help is much appreciated 

Thanks

Kalyana

[Icey]

Hi @bezawak ,

I have posted one workaround. Please check.

Best Regards,

Icey

[Icey · Accepted solution]

Hi @bezawak ,

Please check if this could meet your requirements:

1. Create columns like so:

bin = 
SWITCH (
    TRUE (),
    [days] >= 0
        && [days] <= 5, "0-5 days",
    [days] > 5
        && [days] <= 10, "5-10 days",
    [days] > 10
        && [days] <= 15, "10-15 days"
)

bin sort = 
RANKX (
    'Table',
    CONVERT (
        LEFT (
            SUBSTITUTE ( [bin], " ", "-" ),
            SEARCH ( "-", SUBSTITUTE ( [bin], " ", "-" ) ) - 1
        ),
        INTEGER
    ),
    ,
    ASC,
    DENSE
)

2. Create a bin color measure.

bin color = SWITCH ( MAX ( 'Table'[bin sort] ), 1, "Red", 2, "Blue", 3, "Yellow" )

3. Set data colors.

4. Then you will get this:

BTW, .pbix file attached.

Best Regards,
Icey

[amitchandak]

@bezawak , Any visual using legend or details can not have conditional formatting and we can not control sequence of color. Please see there might be an idea on that. Vote for that or log a new one.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

[AllisonKennedy]

You could use the Theme and Sort Order for the bins, so that the default colours match the colours you want the bins to adopt. So basically, updating the theme in json to have the first few colours equal to the selected bin colours, then add a sort order on the Bin column to always sort in the same order, even when the bins change in the back end. Does that make any sense?

[jdbuchanan71]

@bezawak 

Try re-applying your theme to the .pbix file after categories have changed.  What I have seen is colors 1, 2 and 3 will be applied to categories 1, 2, and 3 (0-10, 11-20, 21-30) and when the categories change it applies the next colors to the new categories.  Re-applying the them applies colors starting at 1 to the new categories.