Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I've set conditional formatting as:
an arrow down if it's below 5% of the % vs LY Green if above based on % vs LY. However some of the rows are not detecting any conditional formatting even though the data is there and showing. Any reason why it might be showing any contiional formatting for the highlighted rows (yellow)
Thanks
Will
Solved! Go to Solution.
@william0076 , Can you share the conditions?
Also, check it is a % column then 0.05 is 5 %
You can also create a color measure and use the same in conditional formatting using field value option
color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)
Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://youtu.be/M5PvQUy-L_4?t=531
@william0076 , Can you share the conditions?
Also, check it is a % column then 0.05 is 5 %
You can also create a color measure and use the same in conditional formatting using field value option
color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)
Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://youtu.be/M5PvQUy-L_4?t=531
Hello,
Can you share the table structure, dax code and conditional formating page? So we can help you better for this problem. It seems like your formatting cant see the rows it need to be see.
thank you.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |