Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!