Work according with selection ?

[suvechha_b]

Hi All ,

How to select the 'Month' and 'Record Souce Name' as '2019-01-01' and '27' resp. to show the chart '1'. ?

In Chart '2' you can see some of the 'Import Month' are null and some of the 'RB_CALENDAR_PERIOD' is null so I put the logic to show '2019-01-01' when null 

=if(ISNULL([Import Month]),RB_CALENDAR_PERIOD,if(ISNULL(RB_CALENDAR_PERIOD),[Import Month],RB_CALENDAR_PERIOD))

same as 'RecordSource' and 'RECORD_SOURCE_GM_ID' when null show 27.

=if(ISNULL(RecordSource),RECORD_SOURCE_GM_ID,if(ISNULL(RECORD_SOURCE_GM_ID),RecordSource,RECORD_SOURCE_GM_ID))

But , it is not working when I am doing selection  as '27'.

My requirement is when I select 'Record Source' as 27 and Import Month as '2019-01-01' then the chart should show like below results -

sample model attached.