Do you have a dimension (or can you create a dimension) where you can tell if it is gas or oil?
maybe it also works on a measruement, but i'm not sure, never tried.
Here is my example:
I have a dimension "Doelgroep", on which i coloured my measures, like this:
I used this code for coloring the measures:
if(Doelgroep = 'Primair',vRed,
if(Doelgroep = 'Secundair',vBlue))
I put the code here
(Op uitdrukking = On expresion || Uiterlijk = Appearance)
Don;t forget the box "expression is a colorcode" (or whatever it may be in English).
I declared to variables with the Hex codes, you don't have to do this, It is just a normal Hex code:
Does this help?