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.
I'm trying to apply conditional formatting in a PBIX but it doesn't work, in File number 1:
But in file number 2:
Both measures are a calculated variance in percentage format, the formula I'm using is:
Example Formula =
VAR __BASELINE_VALUE = [Metric W-1]
VAR __VALUE_TO_COMPARE = [Metric]
RETURN
IF(NOT ISBLANK(__VALUE_TO_COMPARE),IF(DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)>1,1,IF(DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)<-1,-1,DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE))))
Any reason why the second PBIX it's not showing the same Conditional Formatting format?
Hi @Anonymous,
Have you nested other measures with specific filter functions in your formula that used in 'conditional formatting' feature? It is hard to troubleshooting from your snapshots and formula without any detail data. Can you please share a sample pbix file for test?
How to Get Your Question Answered Quickly
Notice: do mask on sensitive data.
Regards,
Xiaoxin Sheng
Let me do that, I'll attach a PBIX Example
I'll do it within a couple of hours, thanks for the reply
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |