Forum Discussion
Conditional formatting not working on measure
Hi Anonymous and natabird3
I was responding to the post below and got your post also.
As refered by v-juanli-msft mMeasure are based on context so when you have the calculation of the measure without reference to any other calcuttion the aggregation doesn't return any background colour.
Believe that is the behaviour of the table visualization since you can add different levels of context and by default it's summarized with totals if you had an additional level of context as it's refered by adding the column 1 the formatting is applied.
If you use the condittional formatting on a card or a bar chart since the context is based on the slicer and on that visualization it will work correctly.
I agree that this is not user friendly and doesn't make sense. I will put an issue on the forum refering to this.
Interesting. I also did a test with Powerbi regular Desktop June 2020 (aka Cloud? I get so confused by the naming of these versions!) versus the on-prem Server Desktop Jan-2020 verion (aka "black icon").
Result: Works on June-2020, does not work on Server Jan-2020. Hope Server gets that fixed soon.
Hi Anonymous ,
For now the two versions aren't aligned (server vs desktop) the main developments are made on the Desktop version and then pass to the server.
Some time back there were plans to only have a single version so no need to have two programs installed, but I haven't heard anything else about it, what I can say is that server is cacthing up so maybe on a next update they solve that issue.