Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Solved! Go to 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
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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |