Solved: Re: Inactive relationship chart filter

NILU090 · ‎10-17-2022

Hi Team,

i have following data modelling. Both relationships are INACTIVE.

I want to show output chart as per completed date.

also i have added filter of year. so everything should filter as per selected year.

please help me on this.

JorgePinho · ‎10-17-2022

1st - Create a measure somethin like this: Amount_CompleteDate = CALCULATE(SUM(fact[amount]), USERELATIONSHIP(fact[Completed Date], TblDate[Date]))

2nd - Create a Bar Chart and use Date on the X-Axis and the measure on the Y-Axis.

Hope it works 🙂

JorgePinho · ‎10-17-2022

1st - Create a measure somethin like this: Amount_CompleteDate = CALCULATE(SUM(fact[amount]), USERELATIONSHIP(fact[Completed Date], TblDate[Date]))

2nd - Create a Bar Chart and use Date on the X-Axis and the measure on the Y-Axis.

Hope it works 🙂

Inactive relationship chart filter