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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
I am using the Preview Matrix and the rows are driven by dates. The drill down function is working as desired (Year, Quarter,Month) UNTIL i get to day. When I drill down to the day it groups the infromation by day number instead of individual days. So if I have 2 months worth of information and I drill down to day , day 1 is the totals for both 1st days.
Is it possible to list each indivdual day ?
Thank You.
Brett
Solved! Go to Solution.
i dont think this is a matrix specific "issue" that is how the drill down on dates work in most visuals, i usually just create my own hierarchy in the date table and replace date for day. or alternatively change the date date not date hierarchy in the visual there is a drop down that allows you to switch between the 2 views when you click on the date field
Proud to be a Super User!
i dont think this is a matrix specific "issue" that is how the drill down on dates work in most visuals, i usually just create my own hierarchy in the date table and replace date for day. or alternatively change the date date not date hierarchy in the visual there is a drop down that allows you to switch between the 2 views when you click on the date field
Proud to be a Super User!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 86 | |
| 85 | |
| 68 | |
| 64 |