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.
We have 3 date slicers Invoicedate, Sales date, order date.
The date in the slicers are populated from 3 copies of the same table (KPI_DATE) to avoid loop in the data model
Invoicedate--> (KPI_DATE1)
Sales date--> (KPI_DATE2)
order date--> (KPI_DATE3)
Our goal is to calculate 3 measures Invoice_KPI_count, Sales_KPI_Count,Orderdate_KPI_Count based on date selected in the date Slicer (Invoicedate,Sales date,order date).
Now as per the user requirement these 3 dates should always remain same i.e if they selected invoice date range is between 01/01/2018 and 12/31/2018, then Sales date and Orderdate ranges should also be between 01/01/2018 and 12/31/2018.
.
In current scenario we are manually passing the dates separately in 3 diffrent date slicers. So, is there any way to pass the date range in 1 date slicer (invoice date) so that other 2 date slicers (Sales date,Order date) should also be populate in the same date range.
Thanks,
Mahi
Solved! Go to Solution.
Hi @Mahi1827 ,
We shoud create a CALENDAR table like that and establish relationship between tables.
date = CALENDARAUTO()
Then we can filter our visuals based on the date table.
Hi @Mahi1827 ,
We shoud create a CALENDAR table like that and establish relationship between tables.
date = CALENDARAUTO()
Then we can filter our visuals based on the date table.
You need to create a common date table and join with all dates. If they are in the same table one will active and others will be inactive. You can make them active using userelation.
This blog has the example for the same :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |