Submitted on07-14-202206:52 AMSubmitted byTallesLessaon07-14-202206:52 AM
Hello all, I was trying to conditionally format the data labels colors based on a measure. Here is my conditional measure : Indicador Payback = VAR checkant = CALCULATE('Metricas Consolidado'[Check Payback],DATEADD('Calendário'[Data],-1,MONTH)) VAR checkatual = 'Metricas Consolidado'[Check Payback] IF( checkant = FALSE() && checkatual = TRUE(), TRUE(), FALSE()) RETURN IF(indicador =TRUE(),"red","blue") Using it in a waterfall graph (does not work on a column chart either) the month oh 06/2022 should be colored red however it comes out as blue I know the measure is working because I have tested it on a table and it works (returns red or blue accordindly and the red output is only on june) also using it as a tooltip over the graph above it is displayed correctly as well (the other months show up as blue) It is configured corretly Also if I try a simpler conditional formatting it is not working as well (should have turned everything below 0 into a red font) but does nothing. https://drive.google.com/file/d/1yny_A6lk8H2denKPHl2ZW-Zw1ATLiF6V/view?usp=sharing Posted it on sissues and was told by a MS representative that "The current position, waterfall map can only support font color uniform modification, can not be defined individually." So I cannot change the color of a columns, witch is usefull to highlight turning points or any other point of interest.
... View more