Forum Discussion
Graph output not showing Correct
- 5 years ago
Hi sakshikaul ,
In order to make the data output correct, I created a table to store the 12 months from January to December. Associate it with the month column of the DBALLSTAT table, and set the filtering direction to single. Then modify the measure:
previous year = var Selectvalue = CALCULATE( [SelectYear], FILTER( ALL('DBALLSTAT'), 'DBALLSTAT'[Eco_year] = MAX('DBALLSTAT'[Eco_year])-1 && DBALLSTAT[Month] = MAX(DBALLSTAT[Month]) ) ) var notselect = CALCULATE( [SelectYear], FILTER( ALL('DBALLSTAT'), 'DBALLSTAT'[Eco_year] = MAXX(ALL(DBALLSTAT),'DBALLSTAT'[Eco_year])-1 && DBALLSTAT[Month] = MAX('Month'[Column1]) ) ) return IF( ISERROR(ALLSELECTED(DBALLSTAT[Eco_year])), notselect, IF( ALLSELECTED('DBALLSTAT'[Eco_year])=2021, notselect, Selectvalue ) )In my sample data, I have successfully fulfilled your requirements, please check the PBIX file for more details.
Hi sakshikaul ,
In order to make the data output correct, I created a table to store the 12 months from January to December. Associate it with the month column of the DBALLSTAT table, and set the filtering direction to single. Then modify the measure:
previous year =
var Selectvalue =
CALCULATE(
[SelectYear],
FILTER(
ALL('DBALLSTAT'),
'DBALLSTAT'[Eco_year] = MAX('DBALLSTAT'[Eco_year])-1
&& DBALLSTAT[Month] = MAX(DBALLSTAT[Month])
)
)
var notselect =
CALCULATE(
[SelectYear],
FILTER(
ALL('DBALLSTAT'),
'DBALLSTAT'[Eco_year] = MAXX(ALL(DBALLSTAT),'DBALLSTAT'[Eco_year])-1
&& DBALLSTAT[Month] = MAX('Month'[Column1])
)
)
return
IF(
ISERROR(ALLSELECTED(DBALLSTAT[Eco_year])),
notselect,
IF(
ALLSELECTED('DBALLSTAT'[Eco_year])=2021,
notselect,
Selectvalue
)
)
In my sample data, I have successfully fulfilled your requirements, please check the PBIX file for more details.
Hi,
I am getting an expected output if I am selecting year=2021 as shown below....
but if I want if I select year =2020 then I want the comparison for current year anr previous year ( basically I want on dynamic selection - whichever year user will select the data should be reflected for the selected year and one year previous to the currently selected year )
In below case if I select year=2020 then only 2020 data is shown, whereas data for 2019 should also be displayed.