Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Employee Table:
I want to have one slicer which is some date - Now whatever value we select in slicer that should get filter below case.
1. Filter all the dates which are less then selected date
2. Filter all the dates which are greater or equal to selected date or If update dt is blank or null
Two satisfied, I created query parameters follwointg below blog Architeture will be like : -
I tried creating a date table and binding with query paramter and used that parameter to filter Power M query advance editor mode. but it getting filtered based on defulat value of queryparameter but not working when selecting or passing any date to slicer.
Advnace editor code.:
Slicer table
Overall report UI
Hi @Vkashyap ,
If I understand correctly, the issue is that you want to filter the dates based on the slicer selection in the Power Query Editor. Please try the following methods and check if they can solve your problem:
1.Create a new parameter by going to Manage parameters. Set the data type to Date/Time.
2.Connect the parameter to the M query in the Power Query Editor.
let
SelectedDate = #"Table"[Parameter Value]{0},
Source = ...,
#"FilteredRows" = Table.SelectRows(Source, each [DateColumn] < SelectedDate)
in
#"FilteredRows"
3.Click OK to apply the filter and click apply to close the Power Query Editor.
4.You can also view the following link to learn add parameters.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Looking forward to your reply.
Best Regards,
Wisdom Wu
Forgot to mention
1. Apply Filter on all the createdt dates which are less then selected date
2. Apply Filter on all the updateddt dates which are greater or equal to selected date or If update dt is blank or null
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |