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.
Hello Helpful People,
I am currently have a set of reports that I would like to use the cross report drill through feature for. I want to drill based on serial number. I have renamed the columns in each report to match, as well as the table names. I have the option checked in both reports for cross report drilling. I have the toggle switched to on for the target report. (I followed the guy in a cube video). It works, sort of.
What I am getting is the target report with no data in it. My target report right now is just a table with serial number and a few other related columns. My thinking is that by drilling through to this page, it should only show the entries for the serial number I drilled through with. I added a slicer and verified the serial number I used, it had multiple entries in the target report, when I am not drilling to it.
Any Ideas? I am not sure what I could be missing..
Thanks
Solved! Go to Solution.
Update: I figured it out. The two fields were not they same type. One was text and the other was alphanumeric. Lol... I feel dumb
Update: I figured it out. The two fields were not they same type. One was text and the other was alphanumeric. Lol... I feel dumb
User | Count |
---|---|
84 | |
78 | |
71 | |
48 | |
42 |
User | Count |
---|---|
111 | |
54 | |
50 | |
40 | |
40 |