Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi everybody,
I have a summary page report and a drillthrough page report. On the summary page I have two visuals: One bar char and one line chart. On the drillthroug page there is a table visual.
On Y axis of the Bar chart I have a measure of Open records and on X axis the Calendar[Date].
On Y axis of the line chart I have a measure of Overdue records and on X axis the Calendar[Date].
The measures are as follows:
Overdue = CALCULATE(COUNTX(FILTER('Fact'',
Drillthroughs are based on filters (the drillthrough columns you specify), not on measures. Not really clear to me what you are trying to do.
Something like this: https://www.youtube.com/watch?v=8_sJkP1nvsM
but with two measures on the second table. If I add two measures on the drillthrough table visual, the results are not right, i.e. if the values from the bar chart is 10 for the first measure, filtering those values on the drillthrough page I'd get less or more rows, in my example 9 or 12.
I hope I have been clear.
Measures do not matter. You can recreate them or replace them on the drillthrough target. All drillthrough does is impose the filter context from the user choice on the drillthrough target page. You can see that in the "Filters on this page" section where the drillthrough filters are in italics.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 63 | |
| 50 | |
| 41 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 135 | |
| 110 | |
| 50 | |
| 31 | |
| 29 |