Filter two tables using the same filter in powerbi
up vote
1
down vote
favorite
I have two tables showing country data in PowerBI, one table contains sales data in different countries and another shows stats about each country. I then have a dashboard that has a chart from each table. I want a single filter that filters on the country column in both tables.
i.e. If I filter on the US, I will get a chart showing sales data in the US and a chart showing other stats about the US.
The country columns have duplicate values in both tables so doing a relationship between them is difficult. Moreover the tables are not really related to each other as such, I just to filter the data in both so my dashboard updates both charts. Any help?
powerbi
asked Nov 9 at 14:12
Daniel Wyatt
214
add a comment |
up vote
1
down vote
favorite
I have two tables showing country data in PowerBI, one table contains sales data in different countries and another shows stats about each country. I then have a dashboard that has a chart from each table. I want a single filter that filters on the country column in both tables.
i.e. If I filter on the US, I will get a chart showing sales data in the US and a chart showing other stats about the US.
The country columns have duplicate values in both tables so doing a relationship between them is difficult. Moreover the tables are not really related to each other as such, I just to filter the data in both so my dashboard updates both charts. Any help?
powerbi
asked Nov 9 at 14:12
Daniel Wyatt
214
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I have two tables showing country data in PowerBI, one table contains sales data in different countries and another shows stats about each country. I then have a dashboard that has a chart from each table. I want a single filter that filters on the country column in both tables.
i.e. If I filter on the US, I will get a chart showing sales data in the US and a chart showing other stats about the US.
The country columns have duplicate values in both tables so doing a relationship between them is difficult. Moreover the tables are not really related to each other as such, I just to filter the data in both so my dashboard updates both charts. Any help?
powerbi
asked Nov 9 at 14:12
Daniel Wyatt
214
I have two tables showing country data in PowerBI, one table contains sales data in different countries and another shows stats about each country. I then have a dashboard that has a chart from each table. I want a single filter that filters on the country column in both tables.
i.e. If I filter on the US, I will get a chart showing sales data in the US and a chart showing other stats about the US.
The country columns have duplicate values in both tables so doing a relationship between them is difficult. Moreover the tables are not really related to each other as such, I just to filter the data in both so my dashboard updates both charts. Any help?
powerbi
powerbi
asked Nov 9 at 14:12
Daniel Wyatt
214
asked Nov 9 at 14:12
Daniel Wyatt
214
asked Nov 9 at 14:12
Daniel Wyatt
214
asked Nov 9 at 14:12
Daniel Wyatt
214
asked Nov 9 at 14:12
Daniel Wyatt
214
214
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
2
down vote
Create a table that just has the list of unique countries and make a relationship from that table to both other tables. Then use that table for your filter, rather than the country column of either of the two original tables.
answered Nov 9 at 16:04
Alexis Olson
12.2k21633
Thanks. I did this and added it to the page level filter and it worked :)
– Daniel Wyatt
Nov 9 at 16:58
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53227345%2ffilter-two-tables-using-the-same-filter-in-powerbi%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
Create a table that just has the list of unique countries and make a relationship from that table to both other tables. Then use that table for your filter, rather than the country column of either of the two original tables.
answered Nov 9 at 16:04
Alexis Olson
12.2k21633
Thanks. I did this and added it to the page level filter and it worked :)
– Daniel Wyatt
Nov 9 at 16:58
add a comment |
up vote
2
down vote
Create a table that just has the list of unique countries and make a relationship from that table to both other tables. Then use that table for your filter, rather than the country column of either of the two original tables.
answered Nov 9 at 16:04
Alexis Olson
12.2k21633
Thanks. I did this and added it to the page level filter and it worked :)
– Daniel Wyatt
Nov 9 at 16:58
add a comment |
up vote
2
down vote
up vote
2
down vote
Create a table that just has the list of unique countries and make a relationship from that table to both other tables. Then use that table for your filter, rather than the country column of either of the two original tables.
answered Nov 9 at 16:04
Alexis Olson
12.2k21633
Create a table that just has the list of unique countries and make a relationship from that table to both other tables. Then use that table for your filter, rather than the country column of either of the two original tables.
answered Nov 9 at 16:04
Alexis Olson
12.2k21633
answered Nov 9 at 16:04
Alexis Olson
12.2k21633
answered Nov 9 at 16:04
Alexis Olson
12.2k21633
answered Nov 9 at 16:04
Alexis Olson
12.2k21633
12.2k21633
Thanks. I did this and added it to the page level filter and it worked :)
– Daniel Wyatt
Nov 9 at 16:58
add a comment |
Thanks. I did this and added it to the page level filter and it worked :)
– Daniel Wyatt
Nov 9 at 16:58
Thanks. I did this and added it to the page level filter and it worked :)
– Daniel Wyatt
Nov 9 at 16:58
Thanks. I did this and added it to the page level filter and it worked :)
– Daniel Wyatt
Nov 9 at 16:58
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53227345%2ffilter-two-tables-using-the-same-filter-in-powerbi%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
