How to view trends over time for first n number for days

[kdaya]

Hi

How do i get a line graph to show the first n number of days rather than actually a date range

Please can someone help me out,

Thanks

Kunal

[Eric_Zhang · Accepted solution]

---

@kdaya wrote:

Hi

How do i get a line graph to show the first n number of days rather than actually a date range

Please can someone help me out,

Thanks

Kunal

---

A measure as below for your reference, the measure varies according to the N days in a slicer. See more details in the attached pbix file.

First N Days value =
SUMX (
    FILTER (
        ALL ( 'values' ),
        'values'[date] <= MAX ( 'values'[date] )
            && 'values'[date]
                >= MAX ( 'values'[date] ) - MAX ( 'First N Days'[N] )
    ),
    'values'[values]
)

[Omega]

You can apply a visual filter. 

Click on the line chart -> Go to filter section under your visuals -> Change the Filter Type to Top N -> Drag your date column to By Value and enter the number of day you want to see.