Display last 14 days data in a matrix based on slicer selection

[meeradominic]

Hi All,

I have a requirement to display a Power BI report, which has a matrix like below. I want to display a measure (a sum) for only past 14 days from a date selected on slicer. Say if I select 17th January, I should I only see data from 4th January. If I select 16th January--> I should see only data from 3rd January etc. 

Can anyone help, please!!

[v-yiruan-msft · Accepted solution]

Hi @wolfgangkb-work ,

I create a sample pbix file(see the attachment), please check if that is what you want.

1. Assume that there is one date dimension table, and DO NOT create any relationship with the fact table

2. Create a measure as below 

Flag =
VAR _seldate =
    SELECTEDVALUE ( 'Date'[Date] )
VAR _fdate =
    SELECTEDVALUE ( 'Table'[Date] )
RETURN
    IF ( _fdate >= _seldate - 13 && _fdate <= _seldate, 1, 0 )

3. Create a visual and apply the visual-level filter on the visual with the condition(Flag is 1)

In addition, you can refer the following links to get it.

Show Days Before Or After A Selected Date - Advanced Power BI Visual Techniques

If the above one can't help you get the expected result, please provide some raw data in your table (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[meeradominic]

Hi,

Thank you so much for your answer. I tried your method as it is. And it works perfectly in a table. see below.

But when I convert it to a matrix nothing shows up. I couldn't figure out why that is.

But I managed to get required results uisng the other link you shared . Thanks again!!