Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |