last 7 and last 14 days data in slicer

[msudulag]

Hi All,

I have a slicer values like "Last 7 Days" ,"Last 1 Days" and "Last 30 Days" 

If user select "Last 14 days" option the data is showing from 8th to till 14th

but i want data include "Last 7 Days" also.

how can we get this.

i have writen if statement it is not considering .

Please help me on this.

Regards

msudulag.

[v-haibl-msft]

@msudulag

Please try with the solution given in this article. There is a sample PBIX file at the bottom.

Best Regards,
Herbert

[msudulag]

Hi @v-haibl-msft,

Thanks for your reply.

can't we do with out creating model,why because i have one more measure to drag into my report matrix.

if i drag that measure my report showing more data.

Regards

Msudulag.

[v-haibl-msft]

@msudulag

I don't think that we can do it without creating model. You can also do the similar thing using the Relative slicer.

Reference: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/#relativeDateSlicer

Best Regards,
Herbert