Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have two tables, where there is a single active relationship , say 'column_A1' from both the tables. In a paginated report, page 1 has data from table A, and page B has data from table 2. There is a drill-through configured from page 1 to page 2 using the same column_A1. I need the page 2 to be filtered based on column B2 & column B3 also along with column B1(=column A1).
Could anyone help me with this? Please let me know if the question is not clear. Thanks in advance !
Hi All,
I found a way to resolve the issue. Create a concatenated calculated column(with three columns) in both the tables A & B and have an active relation between this created column in both the tables. That way it helps us to solve the issue.
Hi @PB_dev,
It’s not supported now in power bi, you can vote here.
If you want to learn more, please refer: limitations-and-considerations
Best Regards,
Link
Hi @PB_dev ,
Just by reading your scenario, what you can try is keep your other 2 columns on the PAGE 2's following section: along with COLUMN 1:
Just remember to KEEP ALL FILTERS sections ON and move all 3 columns to "Add drill-through fields here" section.
Let me know if this is what you are looking for.
Thanks,
Pragati
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |