Forum Discussion
Design based on multiple granularity fct tables and auto scalling date axis
Hi jaryszek
I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file for your reference. Please take a look at it and let me know your observations.
Thank you for being part of the Microsoft Fabric Community!
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.
Thanks,
Can you please show the example how this model can look like?
Best,
Jacek
Hi jaryszek
I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file for your reference. Please take a look at it and let me know your observations.
Thank you for being part of the Microsoft Fabric Community!
Thank you I will implemented something similar in my model.
Best,
Jacek