Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.