Forum Discussion
Infographic Designer conditional Colors
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!
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
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.
1 Reply
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
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.