Super helpful. Thank you for providing this example; I was not sure where to head when I realized it conditional formatting wasn't available within the calculation item itself.
Hi Exceed Learning, Thanks for sharing this trick! I have used exact same logic. However, formatting couldn't be restricted to intended columns. Can you please let me know, if this is still working like this in current version of PBI and Tabular Editor - 2.17 ?
Thanks. How can I do the following (ISSELECTEDMEASURE does not work in this measure) : Color = IF( SELECTEDVALUE('TI Funnel Checkout'[FC]) IN {"(vs LY)"}, SWITCH( TRUE(), ISSELECTEDMEASURE([Net revenue]), [Net revenue], ISSELECTEDMEASURE([Net units]), [Net units] ) ) So, I am only selecting the (vs LY) only but also I am creating a measure which works for all the SELECTEDMEASURE I put in.. instead of creating one color measure for each.
Hello, awesome video! I am having trouble as my CondtionAbs is returning the full value of the YTD instead of the difference between YTD and PY YTD any insight would be helpful!
Hi Austin! not sure I understand your question. ConditionalABS should return selectedmeasure which depends on the calculated item from CG. therefore it should return TY vs LY value calculation Item. if it is returning the whole year, I would focus on the YTD TY vs LY calculation item and check if it is returning the correct value.
Hi, I tried to add data bars using the same technique but was not able to format as format by condition is not available in data bars advanced controls. Could you please help me with this issue?
Hi, when I do this process, the conditional formatting ends up working for all columns and I would like it to work for specific columns. I did exactly like you.
Did you try to use Format by “color scale” instead of “rules”? This feature does not work with color scale since it internally transforms blank values to 0, therefore applies formatting to every cell.
![Chino Pacas - Modo Capone (with Drake & Fuerza Regida) [Video Oficial]](http://i.ytimg.com/vi/zjv8TQ0gBkg/mqdefault.jpg)
Super helpful. Thank you for providing this example; I was not sure where to head when I realized it conditional formatting wasn't available within the calculation item itself.
Very straight forward and powerful!!! Thank you for sharing!
great video & easy to understand, Thanks for this video it was really helpful :)
glad it helped :)
Amazing :) Just what I was looking for!
Thanks! Glad it helped!
Hi Exceed Learning, Thanks for sharing this trick!
I have used exact same logic. However, formatting couldn't be restricted to intended columns. Can you please let me know, if this is still working like this in current version of PBI and Tabular Editor - 2.17 ?
Yea, not working for me either.
Simply, thank you!!!
how can this be done (colour formatting) on a card visual (not a matrix)? Tried to use the callout value colour fx but doesn't work
That helped me. Thank you a lot!
Thanks. How can I do the following (ISSELECTEDMEASURE does not work in this measure)
:
Color =
IF(
SELECTEDVALUE('TI Funnel Checkout'[FC]) IN {"(vs LY)"},
SWITCH(
TRUE(),
ISSELECTEDMEASURE([Net revenue]), [Net revenue],
ISSELECTEDMEASURE([Net units]), [Net units]
)
)
So, I am only selecting the (vs LY) only but also I am creating a measure which works for all the SELECTEDMEASURE I put in.. instead of creating one color measure for each.
Hello, awesome video! I am having trouble as my CondtionAbs is returning the full value of the YTD instead of the difference between YTD and PY YTD any insight would be helpful!
Hi Austin! not sure I understand your question. ConditionalABS should return selectedmeasure which depends on the calculated item from CG. therefore it should return TY vs LY value calculation Item. if it is returning the whole year, I would focus on the YTD TY vs LY calculation item and check if it is returning the correct value.
Can we use SELECTEDMEASURENAME instead of a direct measure name&
Great, thank you!
Grate! Thank you a lot!
Hi, I tried to add data bars using the same technique but was not able to format as format by condition is not available in data bars advanced controls. Could you please help me with this issue?
Hi, data bars currently do not support this feature.
@@ExceedLearning Thanks for the response.
I followed all the steps in the video, but it's not working. ;-;
Hi, when I do this process, the conditional formatting ends up working for all columns and I would like it to work for specific columns. I did exactly like you.
Did you try to use Format by “color scale” instead of “rules”? This feature does not work with color scale since it internally transforms blank values to 0, therefore applies formatting to every cell.
Is seems doesn't work with multiple measures in one calc group table
👋👋👋👋