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 all,
looking for a solution to pass a measure selection to my drill through table.
On my main page I have the following visual -
The slicer at a top is a parameter and my measure to calcuate the count is
From the chart visual, there is a drill through that goes to a table, the issue is the table doesn't show me information for the selected parameter.
ie, if Closed is selected then the table should filter to closed and same as the open selection.
Right now, the drill through is only on the month and year.
How can I drill through on Month and year as well as the selected parameter?
@WilliamA , Use calculation group for Meausre slicer, I think that will allow you to drill
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Hi @amitchandak, Thanks for your suggestion however, this does not work properly as the drill through page is a table is a lot of columns.
User | Count |
---|---|
84 | |
76 | |
70 | |
48 | |
39 |
User | Count |
---|---|
111 | |
56 | |
51 | |
42 | |
41 |