Forum Discussion

Frequent Visitor

3 years ago

Solved

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

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...

Need Help

Anonymous
3 years ago
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
Display last 14 days data in a matrix based on slicer selection.pbix53 KB

Anonymous

Not applicable

3 years ago

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.