The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
In my dataset I have a date column and I tried it's data type as Date or Date/Time but in both cases when I am using that column as Axis in Line chart, it is detecting "Date Hierachy" only as Year, not Day, quarter etc. as it suppose to be, what can be the reason for this?
Solved! Go to Solution.
Standard PBI hack seems to work...
Use a Line and Stacked Column Chart or visual with columns. That will allow you to filter to month or quarter.
Then change back to Line or Area Chart and it will maintain the selection.
Throught the forums I have noticed that they have removed some of these hack fixes, sometimes with supporting the feature sometimes not. Just so you know in case it breaks in a future release.
Hope that helps.
@WillT I am using onpremising data. The date hierachy functionality works when my connection is IMPORT. 🙂 However when I change to Directaccess it does work :(. Is this the expected behaviour? Or will Date Hierachy functionality will soon be available for DirectAccess connections? Thanks for your work. - David
This is a real issue that needs to be addressed in my opinion.
Hi WillT,
Is there any update on date drill functionality for the line charts ?
Cheers
I followed this tutorial: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-analyzing-sales-data-from...
It suggests that the line chart does support this now, but I only see years.
Am I doing something wrong or is the tutorial inaccurate?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
79 | |
72 | |
48 | |
41 |
User | Count |
---|---|
138 | |
108 | |
69 | |
64 | |
57 |