Forum Discussion
Helper IIDynamically show data from current selection in slicer till max year in data.
HI, I have a solution for this
we can create a new table using summarize function like thisYear =GENERATE (SUMMARIZE( Summary, Summary[Year] ),VAR StartYear = Summary[Year]RETURNADDCOLUMNS (GENERATESERIES ( StartYear, 2023 ),"s_year", StartYear,"e_year", [Value]))and than we can use year in the slicer and put year range in table and respective so that we can get the desired result
PFA
Best Regards,
Jatin Joshi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IIHi amitchandak , Thank you for your response.
Actually, I wanted to display data in the same format as shown. A year and then its corresponding value.
if user select a single year (e.g 2014) then it should show all the value from the selected year till the maximum year present in the data(e.g -2018 in this case)
2014-15 #value
2014-16 #value
2014-17 #value
2014-18 #value
and if user select 2016 in year slicer then output should be like this-
2016-17 #value
2016-18 #value
and if user select 2018(which is max year in data) in year slicer then output should be like this-
2018-19 #value (only single entry)
Data should be represented in the same tabular format as below-
HI, I have a solution for this
we can create a new table using summarize function like this
and than we can use year in the slicer and put year range in table and respective so that we can get the desired result
PFA
Best Regards,
Jatin Joshi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.