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.
Hi
I have a table with 4 fields:
Project --Task-- start date--end date
P1--Alpha--01/02/2019--12/11/2020
P1--Beta--01/05/2020--09/12/2020
P2--Alpha--01/05/2019--15/12/2020
P3--Alpha--01/04/2019--19/09/2021
I would like to create a slicer based on the min and max of start & end date
I have create a date table and I succed to set the min & max for all table
Slicer is from 01/02/2019 to 19/09/2021
But when I filter the project 1 , it doesn't work .. the slicer gives the same value
I should have only min & max of project1 so from 01/02/2019 to 09/12/2020
Many thanks for your help
Hi @azizdoghmi ,
Please show us your tables, and your expected outcome.
Please read this post to get your question answered more quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Proud to be a Super User!
I have 2 tables:
Table Project:
Project --Task-- start date--end date
P1--Alpha--01/02/2019--12/11/2020
P1--Beta--01/05/2020--09/12/2020
P2--Alpha--01/05/2019--15/12/2020
P3--Alpha--01/04/2019--19/09/2021
Table Calendar:
Date = calendar(min(Project[start date],max([Project end date])
The slicer is based on Calendar Date.
When I filter a project, the slicer should display the min of start date & max of end date ONLY for project 1 and not for all the table
thnaks
Hi azizdoghmi,
Because the slicer will use a column field instead of a measure, when you filter the project, it won't affect on slicer. I suggest you could sumbit this reqirement on power-bi-ideas .
Best Regards,
Zoe Zhi
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |