Forum Discussion

Parihar1980's avatar
Parihar1980
Icon for Helper II rankHelper II
8 years ago

Sales over the year with Dynamic year value

Hello Friends ,  I am working on tablura model for a requrement where I have to show sales for Last 5 year in a chart. Now this Year value is coming from Year Slicer ; so when i clicked 2018 it shou...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

To keep things simple, why can you not just select 5 years instead of just 1?

Parihar1980's avatar
Parihar1980
Icon for Helper II rankHelper II
8 years ago

As per my requirement we have to show data based on selected Year value, so If User will select 2018 we have to diplay record from 2018,2017,2016,2015 and 2014. and As i menationed SELECTEDVALUE funcation is not working in tabular model. So I have to found some ways to display data based in user selection  

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    I can try to solve it with the DATESBETWEEN() function.  Share the link from where i can download your PBI file.

    • Parihar1980's avatar
      Parihar1980
      Icon for Helper II rankHelper II
      8 years ago

      Many thanks Ashish for your kind word. But I can't share the data since its very sensitive and afcourse its assoicated with tabulader model even this is also road block. I am even agree to do this task using sql plus dax combination, I just want to do it since its users expectation.