Forum Discussion
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?
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
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.
2 Replies
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.
Hi,
Thank you very much - exactly what I've needed.
Have a great day!
Regards,
Tim
