Forum Discussion

SGiacalone's avatar
SGiacalone
New Member
7 years ago
Solved

line and clustered column filter

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

  • 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" ) )
    

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support

    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" ) )