Design based on multiple granularity fct tables and auto scalling date axis

Hi jaryszek 

Thank you for reaching out to the Microsoft Fabric Community Forum.

We have reviewed your data model and found it well-suited for managing multiple fact tables at different granularities. Both the fct_amortizedcosts_daily and fct_amortized_monthly tables are properly connected to the shared dim_date table, which supports consistent filtering and alignment in your visuals.

While Power BI does not offer automatic granularity adjustment based on zoom, you can accomplish this by implementing a granularity or parameter table in combination with a dynamic measure. The granularity table or a Power BI field parameter can facilitate day or month selection, and the dynamic measure can reference the relevant fact table. This method allows a single visual to transition smoothly between daily and monthly data, effectively replicating the auto-scaling functionality you described.

I hope this information is helpful. . If you have any further questions, please let us know. we can assist you further.

Regards,

Microsoft Fabric Community Support Team.