Forum Discussion

Aideekub's avatar
Aideekub
Frequent Visitor
2 years ago

Calculation Group - Conditional Colour Formatting - Conflict Color Rule

Dear, Community 

 

I have some problem about condition format after i use calculation group as detail below,

 

On hightlight that is conflict color that I setting in rule.

Here is rule I set.

and this is condition measure

 

 

If need more information please let me know.

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    Aideekub , Use only the Number option if it is a percent column and use a value between 0 to1

    The percentage is for the distribution

     

    refer: Power BI why Rule Based conditional formatting does not work with percent column- Power BI why Rule Based conditional formatting does not work with percent column

    • Aideekub's avatar
      Aideekub
      Frequent Visitor
      2 years ago

      That took reset after I set this criteria in rule as this below,

       

      or this rule

       

      here still same result. (that incorrent number and percentage same as color) 

       

       

  • Aideekub's avatar
    Aideekub
    Frequent Visitor
    2 years ago

    This is I expected as detail below,

     

     

     

    This column builded by individual measure.

     

    SumMTD = CALCULATE([SumActAFC],DATESMTD(DCalendar[Date]))
    SumMTD Previous = CALCULATE([SumMTD],DATEADD(DCalendar[Date],-1,MONTH))
    %IncreaseMTD = IFERROR(([SumMTD]-[SumMTD Previous])/ABS([SumMTD Previous]),SIGN([SumMTD]))
    % Change Month to Date = CALCULATE([%IncreaseMTD],ALLSELECTED(DCalendar[Year&Month2])) << for rule condition formating