Forum Discussion
Dynamically update date for a visual with drill mode
Hi, pchandwade
Thanks for your quick response!
According to your description, you have configured data refresh on Power BI Service, and you have enabled Drill mode. When you drill to the date dimension, the latest data will not be displayed after data refresh, right?
If so, this is the correct representation of Drill mode. For the Drill to date dimension, the Filter will filter a certain month by default. Even if your data contains new month data, the filtered month date will still be displayed.
You can try to clear the currently specified filter in the Filter and then drill again to the latest month date.You can try to click the Eraser icon in the "Filter on this visual" to try to check if it has the new data.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Community SupportHi, pchandwade
According to your description, you update the data in the dataset by republishing each time?
For visual objects, the import mode will display the currently imported data. After publishing to Power BI Service, you can obtain the latest data information through data refresh without republishing to obtain the latest data.
For this , you can refer to :
Data refresh in Power BI - Power BI | Microsoft Learn
If your data source is from local instead of cloud data source, you need to download local data gateway to configure credentials for refresh.
For this , you can refer to :
Power BI Gateway | Microsoft Power BI
On-premises data gateway - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I should have mentioned this in the earlier post, but the data is set-up for automatic refresh. Only for the visuals which have drill-mode "On" the data does not display the latest dates. If the visual was published on the month view, the latest data would show up, but because it is published on the day view, I have to update the visual and re-publish with the current month. Is there any way for this drill-mode to automatically show days of the latest month?
- v-yueyunzh-msft
Hi, pchandwade
Thanks for your quick response!
According to your description, you have configured data refresh on Power BI Service, and you have enabled Drill mode. When you drill to the date dimension, the latest data will not be displayed after data refresh, right?
If so, this is the correct representation of Drill mode. For the Drill to date dimension, the Filter will filter a certain month by default. Even if your data contains new month data, the filtered month date will still be displayed.
You can try to clear the currently specified filter in the Filter and then drill again to the latest month date.You can try to click the Eraser icon in the "Filter on this visual" to try to check if it has the new data.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly