Forum Discussion
Parameters
hello all
how can i create a parameter that filter all values by a specific date for each value
for example :
i have a table with 3 columns : customer_id (PK) , country , register_date ( all data for all countries is from 1/1/2018 )
how can i create a parameter that filters the customer_id by a diffrent and specific date for each a country ?
show only customer_id from Spain that the register_date is >= 2/14/2018
show only customer_id from Canada that the register_date is >= 9/24/2018
show only customer_id from France that the register_date is >= 7/30/2019
Thanks in advance !!!
Anonymous ,
Create a single select slicer based on [country ] column, then create relative date slicer based on [register_date ] column. You can refer to doc below about how to create a relative date slicer.
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Anonymous ,
Create a single select slicer based on [country ] column, then create relative date slicer based on [register_date ] column. You can refer to doc below about how to create a relative date slicer.
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.