Forum Discussion
Color deppending previous week column
Hi, I have a table with sales per city and week. I want to paint the week column that is better than previous in green and in red if it's negative. Is it possible to do it in PBI? This is what i wa...
quickbi ,
for conditional formatting in table ,
right click on this measure name , you will see opt of " conditional formatting", chose on background.
Hi,
Many thanks for your help, but I don't know why didn't let me:
and the measure:
Revenues Week Difference =
VAR CurrentWeek = SELECTEDVALUE('Calendar'[Week Year])
VAR CurrentWeekSales = CALCULATE([Revenues Actual], 'Calendar'[Week Year] = CurrentWeek)
VAR PreviousWeekSales = CALCULATE([Revenues Actual], 'Calendar'[Week Year] = CurrentWeek - 1)
RETURN
IF(
CurrentWeekSales - PreviousWeekSales >0 ,
"green",
"red"
)
I don't know why did not let me...no warnings, only a square border in red
Okay , quickbi see you have to select that drop down arrow on red borederd box , then a list will appear of all your table names and search for the Measure name "Revenues Week Difference", then select it and click "ok" .
Hope this helps.
If you still have a doubt please let me know.
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!