Need another Tooltip Measure I believe for chart last 3 years

[bdehning]

I got some great help recently on a chart to only show 3 years of customer data..

I have other charts on my dashboard that have different X and Y Axis Columns.  

My report is started by selecting a customeron a slicer.  Customer data may be up to 10 years but many may only have 1 or two years and may go back to 2021 and 2020.  

I use an all page filter to allow 10 Years using IssueDate for all pages.  

I can add IssueDate to a specific chart and that allows me to see the actual IssueDates available for the Customer selected.  If I do that and then try to use last 3 years to get my data it uses today as looking back point.

What measure could I use for the charts so that it would show up to 3 years of data for any customer selected by the original slicer.  

Need help. 

[v-nmadadi-msft]

Hi @bdehning ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[bdehning · Accepted solution]

It did not work for my situation. I was able to reolve it using a different measure.

Thanks for your efforts.   

[v-nmadadi-msft]

Hi @bdehning ,

We really appreciate your efforts and for letting us know the update on the issue.

Please share a short description of the Dax measure that has worked for you and accept that as the solution so as to help other community members.
Please continue using fabric community forum for your further assistance.
Thank you

[v-nmadadi-msft]

Hi  @bdehning ,
Thanks for reaching out to the Microsoft fabric community forum.

You can use DAX measure similar to the one below to only show customer data from last three years,

ShowLast2Years =
VAR MaxYear = CALCULATE(MAX('YourTable'[YEAR_ID]), ALL('YourTable'))
VAR MinYear = MaxYear - 2
RETURN
IF(
    'YourTable'[YEAR_ID] >= MinYear,
    1,
    0
)

Please note that to apply the filter, drag the Created measure into the visual level filters pane of your bar chart. Then, set the filter condition to is 1. This will ensure that the chart only displays data for the last Three years in your dataset.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

[amitchandak]

@bdehning , If you select a date or value and then want to have a range refer

Create a 12-Month Trend with Single Slicer Selection on the connected Date table- https://youtu.be/7dPrPk6LPYU

[bdehning]

I do not need or want a range or date to select.     I need a measure that restricts the data to three years sutomatically based upon the customer selected on first page of report.