Slice between multiple data source

[Anonymous]

Hi,

Is there a way that I could implement a slicer to filter multiple data sources for visuals?

For example, I have imported data sources A, B, and C. I would like to put a Slicer, for example, that has 'button' A, B, and C and if I click on A, charts will display measures for A data source, if I click on B, charts will display measures for a B data source. 

[Icey]

Hi @Anonymous ,

Has @parry2k  solved your question?

Best Regards,

Icey

[parry2k · Accepted solution]

@Anonymous you can surely do that, assume you have 3 measure in each table

Measure A = SUM ( TableA[Amount] )

Measure B = SUM ( TableB[Qty] )

Measure C = SUM ( TableC[Sales] )

Display Measure = 
VAR __selectedSlicer = SELECTEDVALUE ( SlicerTable[SlicerColumn] )
RETURN
SWITCH ( __selectedSlicer,
"A", [Measure A],
"B", [Measure B],
"C", [Measure C]
)

Now you can you Display Measure in your visuals