Forum Discussion
How do I create a conditional colour rule in Charticulator?
Hi HamidBee
I may be over-simplifying this, but I'd have a measure like...
colour = IF(["your measure"] > 0, "P", "N")That'll create a measure that's based on "your measure" which will be "P" of your measure is positive, or "N" if negative. Use that exactly like Ruth did in her video and you should be good.
Stuart
Hi HamidBee
I may be over-simplifying this, but I'd have a measure like...
colour = IF(["your measure"] > 0, "P", "N")That'll create a measure that's based on "your measure" which will be "P" of your measure is positive, or "N" if negative. Use that exactly like Ruth did in her video and you should be good.
Stuart
Stuart! It worked like a charm, thanks alot. I created a measure using the IF statement you provided. I then dragged the measure into the line glyph's colour. Green for P and Red for N.
Hi HamidBee
Great! glad I could help.
You may be interested in our blog, which has lots of charticulator information...
and look out for our book on Charticulator, due to be published soon, which is a full reference to this brilliant tool.
Stuart
Yes I'll definitely take a look. Thanks. Out of curiosity are you a Microsoft or Charticulator stakeholder/employee?.
No, I run a Training company that specialises in Training on Power BI and associated topics like Charticulator. Other than being a user of their products I have no other link to Microsoft/Charticulator.
Stuart