Forum Discussion
lferrier
4 years agoNew Member
Conditional formatting - problem with icons set
Hello, This is my first report with Power BI so bear with me 😉 I try to replicate a view from an Excel file (see below) in Power BI. In the original file, there are multiple lines for one proj...
- 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.