Forum Discussion
Conditional formatting - problem with icons set
- Anonymous4 years ago
Hi lferrier ,
Icon names used in DAX is listed in the blog, you could kindly refer to: Power BI Icon Names for Conditional Formatting Using DAX - RADACAD
So Assume you want to set a icon based on conditional formatting for a Sum value of each Project, please try:
Measure = VAR _phase = CALCULATE ( SUM ( 'Table'[Phase] ), ALLEXCEPT ( 'Table', 'Table'[Project Name] ) ) RETURN SWITCH ( _phase, 0, "CircleEmpty", 1, "Circle25", 2, "CircleHalf", 3, "Circle75", 4, "CircleFilled" )Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi lferrier ,
Icon names used in DAX is listed in the blog, you could kindly refer to: Power BI Icon Names for Conditional Formatting Using DAX - RADACAD
So Assume you want to set a icon based on conditional formatting for a Sum value of each Project, please try:
Measure =
VAR _phase =
CALCULATE (
SUM ( 'Table'[Phase] ),
ALLEXCEPT ( 'Table', 'Table'[Project Name] )
)
RETURN
SWITCH (
_phase,
0, "CircleEmpty",
1, "Circle25",
2, "CircleHalf",
3, "Circle75",
4, "CircleFilled"
)
Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.