Forum Discussion
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
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
Community Support
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" ) )