How to use color formatting using Dax?

[mdaamirkhan]

Hello All,

How to use color formatting using Dax? Is there any query?

Thanks

Aamir

[Vikram123]

Prepare new column with number insted of color.

and use conditional formating with Format by Rule

now you can give color based on your number.

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

[MattAllington]

No, you can’t do it using dax. But there is conditional formatting in the table and matrix visual

[mdaamirkhan]

ok If I want set color in unicode then how will I set the color ?

[v-xjiin-msft]

Hi @mdaamirkhan,

As I know, currently it is not supported to define color in unicode in Power BI. 

But we can use Conditional Formatting feature to format colors based on conditions. However we can only select colors in this feature not custom them in unicode. Please refer to following article: https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

Thanks,
Xi Jin.

[mdaamirkhan]

Come on This thing I know that. fisrt ready my question and understand that as well. 

Thanks.

[mdaamirkhan]

Hello All,

How to give formatting color in unicode in power bi using dax. is there any dax query. Please send me the query how to use

Thanks

Aamir