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.
Firstly If I am not selecting any year filter [ie dballstat(year)] then I am getting correct value as shown in mage
But when I am selecting dbalstat(eco_year)= 2021 the I am getting values for that year only as shown in below :-
Third thing is that if I am taking only one measure , on axis-month, legend as eco_year then, selecting - volume with no eco year filter(no year is selected) then I am getting correct value
as shown below:-
but if I am adding more than one measure in a chart it is getting automatically added in a tooltip and then selecting GP, on axis- month, legend- year, I am not getting value for GP
shown below
please help
- v-kkf-msft5 years ago
Community Support
Hi sakshikaul ,
If your report does not contain sensitive data, can you share your report? It will help us solve the problem faster.
Best Regards,
Winniz - sakshikaul5 years ago
Helper III
No, I cant share my application as its containing comapny's data.
I am very close to the solution. I just want now Previous year measure (2020) its showing data for only last two months whereas 2020 should show complete data from jan 2020 - dec 2020.. Plesae help