Trying to set up calculation groups in order to show daily or monthly costs

[jaryszek]

Hello,

I have a model like that:

And trying to set up calculation groups to show amortized cost (daily or monthly) based on a selection from slicer. It should also adjust X-axis on the chart. So if Day is chosen, we want to have days on X-axis, if MonthName, we want to see Month total amortized cost. 

I put the slicer:

And now I want to show, based on selection,the total amortized cost daily or monthly:

Total Amortized Cost (Daily) = 
    SUM ( 'fct_amortizedcosts_daily'[CostInBillingCurrency] )

Total Amortized Cost (Monthly) = 
    SUM ( 'fct_amortized_monthly'[CostInBillingCurrency] )

My calculation group:

My chart:

How to do this? 
Is it possible to change X-axis based on selection? 

Maybe with using a field parameter connected to MonthName and Day? 
Can anybody help?

My model is on my disc:
https://drive.google.com/file/d/16EOv3bVoeVKhIpyb0AqhJnx3CVI_M3yy/view?usp=sharing

I have watched all available videos but didn't find the same schema approach like mine.

Best,
Jacek

[pbiuseruk]

The only way I've seen of changing the axis on a visual is to use field parameters - worth trying to inject the field parameter into the calculation group. I haven't got much experience with calculation groups but this is very easy to do with normal dax measures.

[v-menakakota]

Hi @jaryszek ,
Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @pbiuseruk   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the below details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team  

[jaryszek]

Hi,

nope it didn't unfortunately it is just a general statement.