topic Re: Conditional Formatiing help in DAX Commands and Tips

Conditional Formatiing help

pmadam — Tue, 09 Apr 2024 22:54:44 GMT

Team,

I need help with having condional formating added in colors or icons for values when greater compared to previours year.

Eg /: countdata in values if its igreater than competitor previous year, it should give be green else red.

Please help

Re: Conditional Formatiing help

Anonymous — Wed, 10 Apr 2024 02:47:04 GMT

Hi pmadam ，
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create a column

Color = VAR _t = 'Table'[Domain] RETURN IF( ISNUMBER( LOOKUPVALUE( 'Table'[TotalCount], 'Table'[Domain], _t, 'Table'[PriceDate], DATEADD('Table'[PriceDate], -1, YEAR) ) ), IF( 'Table'[TotalCount] > LOOKUPVALUE( 'Table'[TotalCount], 'Table'[Domain], _t, 'Table'[PriceDate], DATEADD('Table'[PriceDate], -1, YEAR) ), "green", "red" ), "green" )

Use the column as the filed value of conditional foramtting of the [TotalCount]

Final output

Best regards,

Albert He

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

Re: Conditional Formatiing help

pmadam — Thu, 11 Apr 2024 03:22:13 GMT

I get error msg " multiple values was supplied where a single value was expected" . Is it because of duplicated data in it. Please help with resolution

Re: Conditional Formatiing help

Anonymous — Tue, 16 Apr 2024 09:21:53 GMT

Hi pmadam ,
According to your description, this error occurs when two values are compared to each other, and you need to give both sides of the equation unique values to compare. In the previous code, the applicable case was to create a calculated column instead of measure.

Best regards,

Albert He

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

Re: Conditional Formatiing help

Anonymous — Wed, 24 Apr 2024 09:52:40 GMT

Hi pmadam ,
Whether the problem has been solved. If there are other related issues you can continue to provide details below.

Best regards,

Albert He

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