Visual Data Color value from Table

[Beowulf005]

Trying to figure out a method of defining the color scheme of visual based on a table.

Use case. Working on ticket metrics for support groups and we want to define the color of each support group, so it remains the same across all reports and visuals. Not sure if this would be a JSON color scheme or a linked table.

So, example would be

What I get

What I am looking for

* Did the colors manually for the screenshot

[v-kelly-msft · Accepted solution]

Hi  @Beowulf005 ,

Sorry,as of now,pie chart doesnt support color formatting.

I have a workaround for you:

First create a column as below:

Color = LOOKUPVALUE('Table (2)'[Color],'Table (2)'[Group],'Table'[Group],Blank())

And a measure :

color picker = SWITCH(SELECTEDVALUE('Table'[Color]),"Blue","#15B3E5","Green","#2BE515","Red","#E51525")

Then create a "clustered column chart",choosing color formatting as below:

And you will see:

Then change the visual to pie chart,you will see the color setting is saved:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!