Want to add a filter which gives us data up to selected date

[MKumar_17]

Hi Team,

I have date field as start_date.(1jan-2020-31-Dec-2025). When I am using start_date as filter, it is giving me only selected date output. I want to see data prior to that date also. 

e.g. If I selected JAN-24 in filter it should give me data upto jan-24 data (from 1jan-2020-31jan-2024).

Please share!

Thanks!

[v-yohua-msft · Accepted solution]

Hi, @MKumar_17 

Maybe you can use Slicer visual. Based on your information, I create a table. 

Then create a new table Date in Power BI with a period range of 1/1/2020 to 12/31/2021.

It is a one-to-many relationship between two tables, and then put the date in the Date table into the slicer, and move the slicer to get the effect you want. If you selected 1/24/2020, you can get the data after 1/24/2020.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

Best Regards

Yongkang Hua

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

[alraawygroup]

Hello everybody,

good greeting,

Kindly, I would like your quick support to solve my problem, which is: that I cannot create a Microsoft Power BI Desktop account.

Where I get the following error message (Sorry, we need additional information to verify your identity. Please contact support)

What additional information do you require me to provide? Where do I submit it?

Note that the official email I use for calls is: bi@salmanfadhil.store

Japanese note: The attached picture shows the problem.

With great appreciation,

[MKumar_17]

@amitchandak  Please help me on this issue.