Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have a chart when I select filter it is not reflecting
used dimension: =aggr(if(JNum>=$(vMTrend),MonthName([JDate])),[JDate])
measure1: count({<[FStatus]={'Joined'},[In/Ex]={"In"}>}[ID])
meausre2: count({<[FStatus]={'Joined'},[In/Ex]={"ex"}>}[ID])
selected In/Ex filter the chart is not reflecting
now one value selecting that chart displaying with two lines one with values one with zero line
so I want to hide zero line
Why don't you just use a pivot table and use In/Ex as your pivoted dimension? and a single expression like this
count({<[FStatus]={'Joined'}>}[ID])
okay thanks sunny