Solved: Slice between multiple data source

Anonymous · ‎11-29-2019

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.

parry2k · ‎11-29-2019

@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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

Icey · ‎12-02-2019

Hi @Anonymous ,

Has @parry2k solved your question?

Best Regards,

Icey