Set Power BI Data Color All Visuals to Follow Same Color for the Same Data Point

[@marcussilfver4820]

Good video, thanks for this. I just can't believe how hard a simple task like changing color on data presentation can be!
Power BI needs to make this WAY easier. I miss the old "Data Colors" section in the UX. It used to be so easy, and they totally broke it.

[@anthonypcheng3167]

Thanks, good tip. However, it seems this will work only when there are no Legends involved.
When the "Legend" is involved with multiple data points, I no longer see the option "Default" and button "fx" under "Column" option. Instead, it will only show pre-set colors under Column that we could change manually one by one. No button "fx" appears.

[@RADACAD]

That is right. Legend in a visual will change the color settings of it. You cannot have both the legend and also the conditional formatting.

[@telesforosotelogalindo3114]

@@RADACAD Ok, I already have the answer

[@weiwu1189]

@@telesforosotelogalindo3114 Did you find the solution for change color settings for multiple data points? if so, could you please share? Thanks

[@ildashabani2358]

@@RADACAD Is there any solution on this topic yet? Still need to change the colours in a Stacked Column Chart manually?

[@J0schua]

Is there any way to have the same color across many visuals with stacked bar charts as well ?

[@BeholdNails]

Good tip. I do something similar but without the table, just a Switch in the measure. For example:
Data Color =
SWITCH( SELECTEDVALUE( DimCustomer[EnglishEducation]),
"Bachelors", "#3cc7d5",
"Partial College", "Khaki",
etc.
Then I also have another one for Font Color, for when there will be text on top of the colors in Data Color. For that one I just use "Black" and "White" as the output of the Switch.

[@RADACAD]

That is also good.
Having it as an external table helps in changing the colors without opening the PBIX file though. Otherwise, they both are good methods :)

[@cosmincirnu1036]

Did you discovered a workaround for line chart to align to the same colours as the other visuals which you presented? Thanks! Cosmin

[@AmyCustomer]

Thanks for this video. I was wondering what the best method for this would be. This video is excellent.

[@RowellLagman-ht1qg]

Thanks for this! Very helpful. Doesn't work on line graph though. Are there any workarounds?

[@GG-ep1vh]

@RADACAD thank you for your legendary advice!!! this video is a hit!!! Just wondering if you were able to find a workaround for the line graph? Unfortunately, this is the top used visualisation which is creating major problems due to the manual inefficiencies with updating

[@GG-ep1vh]

thank you for your legendary advice!!! this video is a hit!!! Just wondering if you were able to find a workaround for the line graph? Unfortunately, this is the top used visualisation which is creating major problems due to the manual inefficiencies with updating

[@monicakim777]

Hi thank you for the video. This was really helpful! I have used this to get the colors aligned. However, when I make it as a line chart and use data value to legand the color table does not work. Is there a video you made to fix this?

[@NaomyOliveira-op7dh]

I had the same issue. Did you find a workaround by chance? If you did, can you share it with me? I copied and pasted the format as suggested but it didn't apply to the line chart.

[@emilmubarakshin49]

Thank you this looks great. The next step for it would be to do highlighting in color :)

[@SerendipitySunday]

Great Tip, exactly what I was searching for. Is there a limit to the use of HEX Codes? For some reason just a subset of the Hexcodes used are displayed even though my colouges filled out the Excel Sheet with corresponding HEX Codes. Somehow it stays blank. (blank = default colour)
Keep up the great work

[@schajuli1991]

What if I have a stacked bar, and have multiple colors in one bar e.g. sorted by different years - what would I have to change in the formula?

[@Angecardoza]

Is there a way to do this coloring when you have a legend...and need to color code per legend? When I click on the Cluster Columna and have a legend value along with axis it does not give me option to input a funcion.

[@ssomtom]

Thank you. But I would like to use it with colors belong to Product Category. I want to reach if I have Products in the visual Products color would get automatically the relevant Product Category's color. Of course, I have relationship between categories and products

[@jayrathod2601]

Can apply same color in second level, for e.g if select Purple color and going on drill level same color should be come, is it possible?

[@wexwexexort]

What if I need to make stacked bar chart with 2 categorical dimensions using both axis and legend?

[@RADACAD]

At the moment the setting of legend as conditional formatting isn't yet available unfortunately. Hopefully in the future such thing become an option.

[@emilioleone5514]

@@RADACAD your video is very good and well explained! However I had the problem that a stacked chart is displayed in different way in desktop and in web views (maybe a bug?). I wanted to use your control method but as said above it is not possible yet.

[@AriffShaik-l3c]

This solution is not working on Stacked bar chart where color is deactivated due to series selection. I am stuck and the colors always change when published on dashboard

[@vinaybk1799]

Hi, Can we connect PBI with Azure migrate API as a data source

[@SirTupsAlot]

This is fine when you have a small number of pre-determined categories to color, but not very useful when there are many categories or the possibility for new categories to appear. A more difficult (but useful) solution would be to programmatically assign a color.

[@robwgriffith]

I've been trying to find a way of doing this for ages. I'm thinking this will also allow me to add a single legend to a page rather than having one in each visual.

[@RADACAD]

I am glad it helps :)

[@Outalwajih]

Very Useful Reza. Thank you so much

[@RADACAD]

You're most welcome

[@abhishekstatus_7]

This is awesome, Thanks for sharing Reza ..

[@RADACAD]

Glad you enjoyed it

[@samanthabalbuena2812]

Hi, how I can set the same colors to different tables in the same sheet?

[@PedroCabraldaCamara]

Very good Reza. Thank you so much

[@RADACAD]

You are most welcome

[@danielsiffredi8403]

Brilliant! thanks for sharing!

[@RADACAD]

Glad you enjoyed it!

[@AlNazari-p9w]

3:24 Your welcome!

[@arwaalzagri5245]

There is no "show all" in my power bi

[@CSalcedoDataBI]

Thank You.. Very good

[@RADACAD]

Welcome

[@kylejardine6677]

Thanks for this

[@neerajkapoor1050]

Beneficial indeed

[@telesforosotelogalindo3114]

Thank you very much. One question, how can I add that color table to the titles of the series (text), I also want them to have the same color.

[@hi_vishy]

Just awesome

[@RADACAD]

Thanks

[@lucasaxelramalhosantana2041]

veryyyyyyyyyyyyy thank you

[@RADACAD]

Most welcome

[@satishkumardommeti8282]

Cool

[@RADACAD]

Thanks

[@MrStuartmoran]

poor quality audio, great content