Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
1 year 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
    1 year 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
Icon for Super User rankSuper User
1 year ago

Thanks, 

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

Best,
Jacek

v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
1 year 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
    Icon for Super User rankSuper User
    1 year ago

    Thank you I will implemented something similar in my model.

    Best,
    Jacek