Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@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"
User | Count |
---|---|
53 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |