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 va...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    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" ) )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

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