Forum Discussion
Only first 99 dates on some visuals?
Hi Tishchenko,
About the first scenario, if you want to use drill down function, you need to place fields which contains hierarchy in shared axis. Please take a look at this video to know more about drill down:
https://powerbi.microsoft.com/en-us/blog/power-bi-service-update-0106/
About the second scenario, I'm not able to reproduce the issue like yours. My test results is below. Would you mind try it again in your environment?
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi, about first scenario. So, if you remove "Year" from axis (you screenshot #1) -and do drill to "Date" - you can see only first 99 rows. So, this expected behavior?
Ok, in my dataset i'm try add Year to Axis, but I did not see any changes. It's because in my model type of Year field in calendar table is Text. After change Year field to type INT and put on Axis all 3 fields Year+Month+Date, all dates appears after drill down.If remove Year from axis - you can see this:
Secon issue: seems I'm not able to reproduce to now. I'm recorded this video on version 13.0.1100.658, now is 13.0.1100.682. May be this is the reason ))
