how to display multiple data series on one chart controlled by a slicer?

[mj2024]

Hi

I have 3 separate data sources (using DirectQuery) that I want to plot on the same chart.  I am using a bar chart.  I would like to have a slicer that lets me select which series to display.  If I pick data source 1 on the slicer then data source 1 is displayed.  If I pick data source 2 on the slicer then data source 2 is displated.  How can I do this? 

Thank you

[Kedar_Pande · Accepted solution]

@mj2024 

Create a table with the names of your data sources

DataSourceSelector = 
DATATABLE(
"DataSource", STRING,
{
{"Data Source 1"},
{"Data Source 2"},
{"Data Source 3"}
}
)

Create a measure

SelectedData = 
SWITCH(
SELECTEDVALUE(DataSourceSelector[DataSource]),
"Data Source 1", SUM('DataSource1'[Value]),
"Data Source 2", SUM('DataSource2'[Value]),
"Data Source 3", SUM('DataSource3'[Value]),
BLANK()
)

Add the shared axis (e.g., Date or Category) to the X-axis.
Add the SelectedData measure to the Y-axis.

Use the DataSourceSelector table as a slicer. When you select a data source in the slicer, the SelectedData measure dynamically adjusts to display data from the corresponding data source.

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[mj2024]

Hi @Kedar_Pande 

This works!  Thank you!

[v-kongfanf-msft]

Hi @mj2024 ,

Thanks for your feedback.

Adamk Kong

[v-kongfanf-msft]

Hi @mj2024 ,

As Ibenllin said, field parameters are a good choice. Refer to the demo below:

For more details, you can refer to below bolg:

Power BI Field Parameters: What Are They & How to Use Them?| Coupler.io Blog

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You do that with Field Parameters.

[mj2024]

do you have a resource that shows how to do it?

[lbendlin]

Use report readers to change visuals (preview) - Power BI | Microsoft Learn