Forum Discussion
Data Measure
Hello, do one have one an idea.... i calculate backgroud color, dependig on "selected valuse". Do one have an idea how to calculate it by DATA? Excepct, when not "all" than change color. ...
Anonymous , You have use isfiltered
Debitor = IF(isfiltered(Sheet1[Debitor]) , "#FF8C00", "#85b8cb")
Refer: https://www.youtube.com/watch?v=hXg3kRFSGjA
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Anonymous , You have use isfiltered
Debitor = IF(isfiltered(Sheet1[Debitor]) , "#FF8C00", "#85b8cb")
Refer: https://www.youtube.com/watch?v=hXg3kRFSGjA
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Well thank you at first... your sulution is pretty cool but the solution i´m using works also.
But this wasn´t the hint for my problem.
Does ony one know the solution in my case?
Ok, i was to fast, sorry!!!
The solution ist "isfiltered"