Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all
I have a table called List of Items. I also have a column called "Creation Date". i.e. the date each item was created.
I only want to display the last year worth of data on a column chart i.e. Today() - 365
But my bar chart is showing all the data from 2016.
Question: How do I get the chart to show only data for the past one year
I would appreciate help with this issue.
Solved! Go to Solution.
Hi @vincetaylor ,
You could simply use Relative date filter.
Best Regards,
Jay
Hi @vincetaylor ,
You could simply use Relative date filter.
Best Regards,
Jay
maybe you can create a new column and filter that column
Column = if('Table'[creation]>today()-365,"Yes")
Proud to be a Super User!
@vincetaylor Perhaps:
Measure =
VAR __Today = TODAY()
VAR __EarliestDate = __Today - 365
VAR __Date = MAX('Table'[Date])
RETURN
IF(__Date >= __EarliestDate && __Date <= __Today,<some calculation>,BLANK())
Can you please clarify what is meant by the text "<some calculation>" in the last row of your solution?
@vincetaylor That's where you would calculate something. I can't tell from your message and visual what calculation you are doing for you Value in your clustered column chart but whatever it is goes there. If you already have a measure for that, just plug the measure in for <some calculation>.