Different granularity fact tables - how to show on visuals?

[jaryszek]

Hello,

I have Fct_Costs_Daily and Fct_Cost_Monthly with shared Dim_Table. 

How to switch relationships in the visuals to show for example Daily costs on line chart or monthly or both? 
It will be dax involved with button to switch?

How to design it? 

Best,
Jacek

[jaryszek]

thank you very much. 

[v-pnaroju-msft · Accepted solution]

Hi jaryszek,

We appreciate your question on the Microsoft Fabric Community Forum.

Based on our understanding, we reproduced the scenario using a sample dataset with daily and monthly fact tables that share the same Date dimension. We created a shared Dim_Date table containing both Date and MonthStart, established relationships between the tables, and developed measures for Daily Cost and Monthly Cost. Additionally, we created two line charts and used bookmarks with buttons to toggle between the daily and monthly visuals.

Please find attached screenshots and a sample PBIX file that may assist in resolving the issue:
1. Upon Daily button click:

2.Upon Monthly button click:

We hope the information provided helps to address your concern. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.