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.
Here an expamle for anonther measurement
Debitor = IF(SELECTEDVALUE(Sheet1[Debitor]) <> "", "#FF8C00", "#85b8cb")
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/
3 Replies
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/