cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DerMainzer
Helper I
Helper 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
Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors