Show last 15 days of data in stacked column chart?

[Anonymous]

I have a dataset with per-day data, and I would like to just show the last n days (e.g. 15) in the columns.  Here is a current example, but it is showing all of my data:

What is the trick to just show the most recent days? Thanks for the help!

[v-yuta-msft]

@Anonymous ,

The relative date slicer or filter can meet your requirement, please refer to doc below:

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener · Accepted solution]

Hi @Anonymous ,

Use a relative date slicer and filter in Power BI

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

[camargos88]

Hi @Anonymous ,

You can create a column on your table like:

IF(TODAY - DATECOLUMN <= 15; 1; 0)

and filter the results using this new column.

Ricardo