Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !!!
Solved! Go to Solution.
@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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |