Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to show this is visual

Hi Team, I have 5 columns, Project Baseline Q1 Q2 Q3 Q4 B 100% 100% 98%     C 100% 100% 89%     D 100% 100% 100%     E 100% 100% 100%     F 100% 100% 1...
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, Anonymous 

     

    Has your problem been solved? Does my method above help?
    You can create some measures as indicators such as:
    Q1-base=AVERAGE('Table'[Q1])-AVERAGE('Table'[Baseline])


    Note that in the screenshot above, your baseline is counting, which may indicate that this field is a text type. Please modify the type to percentage to calculate it normally.

    It seems like a good idea to use line and clustered column char.

    Please refer to the attachment below for details

     

    Edit:
    or just to create condition formatting rules to highlight the data in a table to see if they have meet the critirica.

    create a measure for each quarter.

    _Q1 = IF(SUM('Table'[Q1])>=SUM('Table'[Baseline]),"green","red")
    
    _Q2 = IF(SUM('Table'[Q2])>=SUM('Table'[Baseline]),"green","red")
    
    _Q3 = IF(SUM('Table'[Q3])>=SUM('Table'[Baseline]),"green","red")
    
    _Q4 = IF(SUM('Table'[Q4])>=SUM('Table'[Baseline]),"green","red")

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.