Infographic Designer conditional Colors

[cristianml]

Hi,

I want to custom the colors of the Infographic Designer values depending if the measure I use is negative or positive. 

Is possible to write a dax code for this ? Also a way to be dynamic by colored depending of % of the values.

Thanks!

[Anonymous · Accepted solution]

Hi @cristianml ,

Here I suggest you to add and use conditional formatting in your Infographic Designer custom visual.

For reference:

Support for conditional formatting for custom visuals

Add conditional formatting

According to your screenshot, I think you can try "Small multiples" funtion in Clustered column chart directly.

My Sample Table:

DimDate:

DimDate = ADDCOLUMNS( CALENDARAUTO(),"Year",YEAR([Date]),"Qtr","Q"&""&QUARTER([Date]))

Create a relationship between [Date] columns in two tables.

Color Measure:

Color = 
IF(SUM('Table'[Sales])>0,"Blue","Red")

Use Field value and choose color measure in fx in Data color.

Result is as below.

Best Regards,

Rico Zhou

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