cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DerMainzer
Resolver I
Resolver I

Connect Sliver tu multiple Fields

Hi, 

I have a slicer for several countries and for each country I have a web connection.

How do I connect The Slicer countries to the different web connections?

05-02-_2023_19-42-17.jpg

Explanation:

Slicer Values (1) gets the countries from List (2)

If I choose Germany the Visual (3) shows the values of my web connection (4)

 

Question:

If I choose another country (e.g. 5) the visual should show the values from connection (6)

 

The Data on the web connections is refreshed daily, it's no permanent.

 

Thanks in advance,

 

Tim

1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

@DerMainzer 

You have two options that I can think of immediately:

 

Option A (WARNING THIS WILL BE EXTREMELY SLOW)

Keep the tables separate as they are now and write a DAX measure using SWITCH to calculate which web connection to sum

 

Option B (recommended option)

Append all the web connections in Power Query:

1) Open Power Query

2) Go to the Germany web connections table

3) Add Column > Custom > = "Germany"

4) Repeate this for each country

5) Append Queries as New > 3 or more Queries > select all the web connections

6) Relate the 'List' from your slicer to the new custom country column in your append query

7) Use the Apped query data in your line chart. 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

2 REPLIES 2
AllisonKennedy
Super User
Super User

@DerMainzer 

You have two options that I can think of immediately:

 

Option A (WARNING THIS WILL BE EXTREMELY SLOW)

Keep the tables separate as they are now and write a DAX measure using SWITCH to calculate which web connection to sum

 

Option B (recommended option)

Append all the web connections in Power Query:

1) Open Power Query

2) Go to the Germany web connections table

3) Add Column > Custom > = "Germany"

4) Repeate this for each country

5) Append Queries as New > 3 or more Queries > select all the web connections

6) Relate the 'List' from your slicer to the new custom country column in your append query

7) Use the Apped query data in your line chart. 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Hi,

 

Thank you very much - exactly what I've needed.

Have a great day!

 

Regards,

 

Tim

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors