Forum Discussion

lferrier's avatar
lferrier
New Member
4 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    4 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.