Forum Discussion
Filter Graph only by one column from a table
To get the behaviour you're after we need to get a bit more intricate. First, you'll need a separate table to use on the axis of the chart. You could create a proper date table or you could keep it as simple as using
Month Table = DISTINCT( 'Table'[Month] )Use the month table on the graph but keep using the 'Table'[Month] column in the table visual.
Create a relationship from 'Month Table'[Month] to 'Table'[Month].
Turn on Edit Interactions and change the behaviour so that your table visual filters the graph instead of cross highlighting it.
Finally, change the measure to be
Num rows by item = CALCULATE( SUM ( 'Table'[sum] ), REMOVEFILTERS( 'Table'[Month] ), VALUES( 'Month Table'[Month] ) )
Hi johnt75
Created the measure above but it does not do what i want.
Added the measure above to the graph but i does nothing .
To get the behaviour you're after we need to get a bit more intricate. First, you'll need a separate table to use on the axis of the chart. You could create a proper date table or you could keep it as simple as using
Month Table = DISTINCT( 'Table'[Month] )Use the month table on the graph but keep using the 'Table'[Month] column in the table visual.
Create a relationship from 'Month Table'[Month] to 'Table'[Month].
Turn on Edit Interactions and change the behaviour so that your table visual filters the graph instead of cross highlighting it.
Finally, change the measure to be
Num rows by item = CALCULATE(
SUM ( 'Table'[sum] ),
REMOVEFILTERS( 'Table'[Month] ),
VALUES( 'Month Table'[Month] )
)