Forum Discussion
Fabric Semantic Model - Continuous X Axis Line Chart
Unfortunately, when using Date field without a custom hierarchy set up Fabric Direct Lake does not support automated hierarchies. For example, if I have a line of % Reponse Rate and want to show that by Quarter that calculates across multiple dates it will not properly aggregate to the Quarter grain.
The only way to respolve this (that I've found) is to create a custom hierarchy, but then I have the issues I laid out above.
This seems like incredibly basic functionality that I should not have to work hard at to resolve. Tableau does this seemlessly.
PowerBI also does this just fine when working with a data source such as an excel or csv file directly, but it can not do it with a Fabric Direct Lake connection as far as I can tell.
Right, sorry for not catching that you are using DirectLake. I think that Microsoft had acknowledged that feature gap a while back and had mentioned they are working on lifting that limitation.
In any case - If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com
Hi cpshort7186 ,
Thank you for the update, Appreciate if you could share the feedback on ourMicrosoft Fabric Ideas Which would be open for the user community to upvote & comment on.
Best Regards,
Community Support TeamI did that, but to be honest it seems like ideas are not well organized on that forum, often have overlap with other posts, and tend to sit there for years before they are acted on (if at all).
Hi cpshort7186 ,
I understand your concern about the Ideas site. From Microsoft’s side, features like this are prioritized based on the number of customer votes and demand. Submitting/voting on the idea ensures it’s visible to the product team, and higher-voted items have a much better chance of being considered for future updates. While it may take some time, this is still the best way to influence the roadmap and get this functionality addressed.
Thank you.
