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

No video

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

Рет қаралды 52,526

Күн бұрын

You can set the color in every visual in Power BI easily. You can also set the color of multiple visuals at the same time using Themes. However, what if you want to set the same color for the same data point? For example, You want the Gender Female to be always colored Orange in all the charts and visuals. In Power BI, as of now, you cannot set a data point color. However, there is an easy solution for that, which I explained in this article and video.
Learn more about from my blog article here:
radacad.com/se...

Пікірлер: 53

@marcussilfver4820 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

@@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 28 күн бұрын

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

@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 7 ай бұрын

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

@BeholdNails 2 жыл бұрын

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 2 жыл бұрын

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 :)

@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

@RowellLagman-ht1qg Жыл бұрын

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

@GG-ep1vh 11 ай бұрын

@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

@emilmubarakshin49 Жыл бұрын

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

@GG-ep1vh 11 ай бұрын

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.

@user-ox2ym8nk4n Ай бұрын

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

@Angecardoza 11 ай бұрын

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

@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?

@wexwexexort 2 жыл бұрын

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

@RADACAD 2 жыл бұрын

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.

@SirTupsAlot 7 ай бұрын

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.

@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?

@neerajkapoor1050 6 ай бұрын

Beneficial indeed

@vinaybk1799 2 жыл бұрын

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

@samanthabalbuena2812 2 жыл бұрын

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

@robwgriffith 2 жыл бұрын

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 2 жыл бұрын

I am glad it helps :)