search

bhavesh-jadav / Advance-Card

Advance Card Visual for Power BI
http://bhaveshjadav.in/powerbi/advancecard/
GNU General Public License v3.0
25 stars 12 forks source link

Conditions Formatting Not #16

Closed adamnimmo closed 5 years ago

adamnimmo commented 5 years ago

Hello, I seem to be having an issue with conditions formatting, I have selected placed a measure within the Data Field (59) and I have a target measure within the Condition Field (45), when I turn on Conditions within the format pane I am not getting the behavior I am expecting.

Based on the documentation I interpreted this as a auto field which will compare Data v Conditions and format properly. Both of my measures are formatted as a whole number w/o decimal places.

If I enter a static value within the Conditions Value box I do get the result expected.

Did I misunderstand the documentation or am I doing something wrong?

Thank you for your help

cards conditions

image

bhavesh-jadav commented 5 years ago

Hi @adamnimmo

When you drop field in Condition field, that value will be used as base value for comparison and will be compared with Value in Conditions which from what I can see from screenshot, you have kept it empty.

If you want to compare MilOOB with OOB_Target then you can create a measure which might look like below.

Measure = IF([MilOOB] > [OOB_Target], 1, 0)

Then drop this Measure into conditions fields and set conditions to 2 and other settings as follow. If Measure value is 1 then red and If it is 0 then set it as green something like that. You will specify 1 and 0 in Value of Conditions

In short, comparison happens between either Datafield value and static value if no Condition field is specified or between Condition field and static value if condition field is specified. So if you want to compare both of them, create a measure which returns different static value based on conditions and use that as conditional formatting.

adamnimmo commented 5 years ago

Brilliant @bhavesh-jadav I figured I was interpreting something incorrectly.

Thank you very much for the reply and for creating this outstanding visual.