line and clustered column filter

[SGiacalone]

Hi,

Is there a way to select which data to assign to line and which to columns in a graph.

For example

Using the database below I am assigning:

Shared x axis: "Index"

Column and line values: "Value"

Slicer: "Process"

How do I assign, say, Process A to columns and Process B to line?

Database

Index  |  Process  |  Value

1         | A             | 0.5

2         | A             | 0.9 

3         | A             | 1.5

4         | A             | 1.3

5         | A             | 0.9

6         | A             | 1.2

1         | B             | 0.9

2         | B             | 0.4 

3         | B             | 1.8

4         | B             | 2.3

5         | B             | 0.2

6         | B             | 1.7

Thank you in advance,

Stefano

[v-chuncz-msft · Accepted solution]

@SGiacalone ,

You may just add two measures.

Measure =
CALCULATE ( SUM ( Table1[Value] ), FILTER ( Table1, Table1[Process] = "A" ) )

Measure 2 =
CALCULATE ( SUM ( Table1[Value] ), FILTER ( Table1, Table1[Process] = "B" ) )