Forum Discussion

jaryszek's avatar
jaryszek
Super User
10 months ago
Solved

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

Hello, anybody created a model for havinf multiple granularity fct_tables (daily, monthly) and shared dimensions? My question is how to make autoscalling x-axis , something similar to this Guy:...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    10 months ago

    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!

jaryszek's avatar
jaryszek
Super User
10 months ago

Thanks, 

Can you please show the example how this model can look like?

Best,
Jacek

v-karpurapud's avatar
v-karpurapud
Community Support
10 months ago

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!

  • jaryszek's avatar
    jaryszek
    Super User
    10 months ago

    Thank you I will implemented something similar in my model.

    Best,
    Jacek