Deneb Pie chart with hexa color from dataset

[Yogi785]

Hello, I am trying to use color from dataset with Hexa colors.

But not seems to work, becase colors are completly wrong :

Colors #293133 is dark grey !!

How to make it working please ?

Thanks 🙂

[Anonymous · Accepted solution]

Hi,

Thanks for replies of lbendlin  and Uzi2019  , and i want to offer some more information for user to refer to.

hello @Yogi785 ， based on your desciption, you can consider to use Treemap, it can set the color.

You can refer to the following sample.

Sample data

Then you can create  a measure to calculate the percentage of each color.

Percentage% = DIVIDE(SUM('Table'[Value]),SUMX(ALLSELECTED('Table'),[Value]))

Then crete a measue to format the color.

Format = SELECTEDVALUE('Table'[Color])

Then create a treemap visual, and put the following field to the visual.

Then click advanced controls under 'colors'

and put the format measue to it.

Output 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Yogi785]

Hello, thanks for replies. In fact I want to associate color with data and amount. This is my dataset : 

We sell colored goods and I want those colors to be represented in the graphic. The grey RAL7016 #293133 is the best selling.

Thanks

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Uzi2019]

Hi @Yogi785 

You can manually set your pie chart color by using slicer setting option. 

but you value itself is hexcolor value. it will not automatically map your hexvalue against hexcolor.

You have to do it manually.

I hope I answered your question!

[lbendlin]

A pie chart ?!?  Why ?!?  🙂

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...