Hex code to colour visibility in slicer

[neha369]

Hello ,

I have a column of hex codes. I want to filter the whole report on the basis of Hex code. How ever in filter i want to replace hex codes with the colur it represents. 

Any thoughts on this ?

[jeevanabattu]

Can anyone please help? I have the same issue, I wanted Hex codes to appear as colors in Slicers.

Please find below screen shot :

[stevedep]

Please see; 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[neha369]

I have a table with column name 

Project name	Hex code
ABC	#32C12C
PQR	#7F4FC9

I want Hex code in slicer to see project name in grid. However I want not the text to be visible in slicer but it should replace by colour. Do any one have idea how to represent the same. 

[stevedep]

This page describes how, mind;

To use this in a visualization, change the Format by option to Field value in the advanced controls, then select the new measure as the source for the formatting. 

https://www.blue-granite.com/blog/controlling-conditional-formatting-using-dax

So you create a table as slicer with coloured cells as described in the link. The cell values (hex codes) can be coloured like the background.

Please mark as solution if this works for you.

Kind regards Steve

[neha369]

Yes, By using conditional formatting we can color the grid background/Font. But my requirement is to make color options available in Slicer itself , so that when the client choose for ex.  red color from the filter it will get project name  in red color.