Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Experts
Is it possible to do the following. I have taken column trend from my FACT table (table A) and added this as filter to my report. Everything is fine. Tables B, C, D and E have the same columns "trend" all tables can be linked together using a common column Co.ID.
Hear goes how can I dynamically point my filter to the right table based on what filter I am using, so if I select manufacturing filter I want to use trend column from table B as my filter in my report as opposed to table A trend column. And
If I select country I want to use trend column from table C as my filter in my report. And so on..
Solved! Go to Solution.
Please can you share a snap of first few rows of your tables to better understand your case.
Please can you share a snap of first few rows of your tables to better understand your case.
Thanks Raj managed to solve the issue it was a relationship issue.
User | Count |
---|---|
85 | |
82 | |
66 | |
52 | |
48 |
User | Count |
---|---|
100 | |
49 | |
42 | |
39 | |
38 |