Forum Discussion

Donny620's avatar
Donny620
Icon for Helper I rankHelper I
2 years ago
Solved

Custom Conditional Formatting for Multiple Columns?

Hi! I've created a sample PBI for my problem, and I'm sorry got it too late and now it's buried in the other thread, if you need to delete this thread please just let me know.  I've looked at a ton o...
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    Donny620 

    I referenced the answer of  MFelix and resolved your problem, I hope it should work for you. I also created a calendar table. 

    Here is the measure that the conditional formatting is based on:

    CF TYPE 1 = 
VAR __50PCT = PERCENTILEX.EXC( SUMMARIZE( ALLSELECTED( Sheet1 ) , Dates[Year] , Dates[Qtr], Dates[QtrNo] ), [Type 1] , 0.5 )
VAR __T1 = [Type 1]
VAR __RESULT = IF( NOT ISBLANK( __T1) , __T1 - __50PCT )
RETURN
    __RESULT


    Result: I added CF based on Power BI default settings on a copy of TYPE 1 measure and renamed to TYPE 1 Comp for comparison.

    The file is attached below 🙂






Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
2 years ago

Donny620 

Regrettably, Power BI currently lacks the capability to dynamically assign values to its conditional formatting, especially concerning gradients, using measures. I am hopeful that the Power BI team will address this limitation in the near future.

I found an idea posted in 2020 and we are wating for this features to be delivered: Microsoft Idea
Please vote for it.