topic how can use measures for comperision in conditional formatting using power bi in Custom Visuals Development Discussion

how can use measures for comperision in conditional formatting using power bi

amal_01 — Wed, 20 Nov 2024 11:34:03 GMT

I made two measures to find the sales amount for this day and the previous day. Now, I want to make a comparison between the amounts. I want to use an up arrow icon and a down arrow icon to show me which value is higher than the other.

I mean like this

I tried to use conditional formatting, but it is difficult to add a measure for comparison."

what sould i do ?

Re: how can use measures for comperision in conditional formatting using power bi

KNP — Wed, 20 Nov 2024 18:10:41 GMT

Hi amal_01,

I'm not sure what your measures are called but hopefully the below generic example will help.

Conditional measure...

__SalesIcon = SWITCH( TRUE() , [Sales] > [Sales SPLY], "TriangleHigh" , "TriangleLow" )

You can see the icon names in this article.

https://radacad.com/power-bi-icon-names-for-conditional-formatting-using-dax

Apply this to the cell elements...

Here the field settings are applied using the measure...

I hope this helps.