Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I met the below problem:
when I select the single year, the chart dimension"Year" will change to the selected year automatically . Could I fix the year , not impacted by the year select .Thanks.
Keep all the dims as they are and try modifying your expression something like this: Sum({<Year=>}Field) and you should have all the years on the x axis even when a year is selected. this expression is ignoring year selections. If you want to ignore Yearmonth selections too: Sum({<Year=,Yearmonth =>}Field).
You can fix this in your expression by ignoring selections on the Year using Set analysis
Just insert this before your expression : {<Year>}
This is in effect saying that you always want all years.
Hi I got your point . But this chart, there are four diemensions. Could I restrict only I select dimension=year, then set the expression. Thanks.
You could ignore all selections by using {1}
Keep all the dims as they are and try modifying your expression something like this: Sum({<Year=>}Field) and you should have all the years on the x axis even when a year is selected. this expression is ignoring year selections. If you want to ignore Yearmonth selections too: Sum({<Year=,Yearmonth =>}Field).