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.
If I write Calculate with filter, create a visual card and select date, it shows correct count
HeaderTbl | ||
HeaderKey | ValidFrom | ValidTo |
H1 | 1Jan2022 | 31Dec2022 |
H2 | 15Feb2022 | 31Oct2022 |
H3 | 10Mar2022 | 15Sep2022 |
H_FebOnly | 7Feb2022 | 25Feb2022 |
H_FebMar | 25Feb2022 | 14Apr2022 |
DetailsTbl | |||
DetailsKey | HeaderKey | Name | Currency |
D1 | H1 | A | EUR |
D2 | H2 | B | GBP |
D3 | H3 | C | AUD |
D4 | H_FebOnly | D | GBP |
D5 | H_FebMar | E | USD |
Dates I try in slicer
Date
31 Dec 2021 |
31 Jan 2022 |
28 Feb 2022 |
31 Mar 2022 |
30 Apr 2022 |
31 May 2022 |
30 Jun 2022 |
31 Jul 2022 |
31 Aug 2022 |
30 Sep 2022 |
31 Oct 2022 |
30 Nov 2022 |
What am I missing?
Solved! Go to Solution.
@alsm , A calculated table, can not take the slicer values. that is why the table is empty
@alsm , A calculated table, can not take the slicer values. that is why the table is empty
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |