Create a measure that can be used to split a line chart (small multiples)

[kempms]

Good day

My predicament:

I need to create several line chart to display the performance of different gas productions.

The  scenario:

I work for a company that produces different gasses (let's call it gas 1, gas 2, gas 3). The factory is split in 2 (East and West), each producing the same gasses. I need to create a graph showing both factories actual production of each gs compared to what the projected production was. So my column names are: Gas 1 East actual, Gas 1 West actual, Gas 1 East plan, Gas 1 West Plan...

To create a graph for each set creates a dash board that is very crowded. So what I want is to have all 4 values on 1 graph for each gas type (3 graphs in all). 

What I was wondering is if it is possible to create a measure that will check the names of each variable and then split the variable according to East/West from the names. then use that measure s critiria in the small multiples box to splitt the chart for East actual + East Plan / West actual + Wets plan

Sample of what graph looks like now with only actual in. Adding the Plan as well makes the graph very crowded.

[amitchandak · Accepted solution]

@kempms , if want to use small multiple feature of the visual, then you need column, measure will not work

You can create a new column

example

Switch ( True(),

[Column] in {"Gas Plan","Gas Actual" }, "Gas",

//Add other

)