Create several color models depending on a referen...

LithanaM · ‎05-03-2022

Dear PowerBi community,

I would love to be able not to have to recreate each time the color scheme I need for some of my datas and to be able to reuse them for future analysis in New PowerBI.

Examples:

when I use my list of age group, I would like to have a specific color for each of them.

when I use a community list, I would like to specify for each of them a different color gradient depending on where they are situated etc.

I have a reference table for both of them, and I added a column with the color reference, but I am struggling in linking them with the fx (in fact, I don't even see the fx sometimes).

Does anyone already created reference colored table to get systematic coloring in their graphs? (or any other way to do it systematically :))

Could you tell me what's the best route to do it?

Thanks a lot for your help!

Nathalie

parry2k · ‎05-09-2022

@LithanaM Thanks for the feedback, much appreciated!

✨ Follow us on LinkedIn and to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k · ‎05-03-2022

@LithanaM check the conditional formatting video on my YT channel and hope it helps you with what you need.

Link to part 1 video: https://youtu.be/s3riB6EtqkY

Link to part 2 video: https://youtu.be/OC7pgwF6ID8

✨ Follow us on LinkedIn and to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

LithanaM · ‎05-18-2022

Hi Perry,

I looked into the solution you proposed, but my color is not dependant on a measure but on a stable column data. therefore I am not sure how to create the VAR_Color measure that I will be able to use then...

I am really a beginner...

See below. I have a simple table with color reference and NomRTS.

I have a transaction table that is linked for the NomRTS.

I would like the legend of the graph below to take the color of my reference color...

Is it possible?

LithanaM · ‎05-09-2022

Thank you Parry2k, nice videos. I haven't had the chance yet to apply it in my dataset, but I am looking forward to try it!

Have a great day,

Nathalie