topic Re: Hex code to colour visibility in slicer in DAX Commands and Tips

Hex code to colour visibility in slicer

Anonymous — Tue, 02 Jun 2020 07:10:22 GMT

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 ?

Re: Hex code to colour visibility in slicer

stevedep — Tue, 02 Jun 2020 09:24:42 GMT

Please see;

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

Re: Hex code to colour visibility in slicer

Anonymous — Tue, 02 Jun 2020 12:57:10 GMT

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.

Re: Hex code to colour visibility in slicer

stevedep — Tue, 02 Jun 2020 13:16:07 GMT

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

Re: Hex code to colour visibility in slicer

Anonymous — Tue, 02 Jun 2020 13:22:24 GMT

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.

Re: Hex code to colour visibility in slicer

jeevanabattu — Thu, 11 May 2023 07:20:22 GMT

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

Please find below screen shot :