Forum Discussion

xcrmadmin's avatar
xcrmadmin
Icon for Helper I rankHelper I
3 years ago

Condition formation per month column

Dear Experts I Am try to format each coulmn in power bi matrix based on the max to min value as gradient color. I did my best and the result not coming as expected. My matrix inlcude monthes and per...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

xcrmadmin , if you want to return color based on values  then you need to define gradient color and there can be limited colors

 

example

Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
)

 

This can be used in the conditional formatting field value option. to make this gradient, one need to lot more condition and color

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

 

xcrmadmin's avatar
xcrmadmin
Icon for Helper I rankHelper I
3 years ago

this my measure but the result not as expected, and i use this measure to coloring the matrix per month name column.

 

CALCULATE ( SUM ( DIM_WON_ANALYTICS[Actual Revenue] ), ALLEXCEPT ('Date', 'Date'[UNMMAE] ) ) IF ( HASONEVALUE ( 'Date'[UNMMAE] ), CALCULATE ( SUM ( DIM_WON_ANALYTICS[Actual Revenue] ) ), MAXX ( ALLEXCEPT ( 'Date', 'Date'[UNMMAE] ), CALCULATE ( SUM ( DIM_WON_ANALYTICS[Actual Revenue] ) ) ) )
  • xcrmadmin's avatar
    xcrmadmin
    Icon for Helper I rankHelper I
    3 years ago

    Then i used below meassure but alos the result not as expected 

     

    SUMX ( FILTER ( ALL ( 'Date' ), 'Date'[UNMMAE] = SELECTEDVALUE ( 'Date'[UNMMAE] ) ), [Total Sales] )