Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Problem with conditional formatting on specific month

I am new to Power BI and now stuck in writing a measure to do conditional formatting.   I want to show if the number of complaints in different business units increase from last month to current mo...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Add +0 to the measure so that will show 0 in place of blank

 

+0 can force left join, so I usuallt prefer.

 

0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))

 

 

If you need color on for oct.

 

the return blank() or white color in else

 

example

Colour =
SWITCH(TRUE(),
max('Table'[Month]) = "OCT", "red", //loop if or switch if needed
"White")

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, 

    +0 works for me now, Thank you!

    However, I sitll can't put color only on September (sorry not October), because when I applied the color measure to conditioning formatting, it applies to the entire matrix.

     

    Even if I add "white" at the end, it still shows yellow over the table, and there are green in August. What I want is only the row of September being colored. Can I add any conditional function in the measure to let it only put color on September?
     
    Color =
    IF(
    CALCULATE(COUNT(Table[Number]), Table[Month]="September")-CALCULATE(COUNT(Table[Number]), Table[Month]="August") > 0, "red",
    IF (
    CALCULATE(Same as above) < 0, "lightgreen",
    IF (
    CALCULATE(Same as above) =0, "yellow",
    "white")))