Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
I have a table that's like this:
Sales Person | Month | Value |
CJ | 01/01/2021 | £100 |
CJ | 01/01/2022 | £200 |
CJ | 01/02/2021 | £150 |
CJ | 01/02/2022 | £250 |
CJ | 01/03/2021 | £200 |
CJ | 01/03/2022 | £250 |
CJ | 01/04/2021 | £500 |
CJ | 01/04/2022 | £1,000 |
For several different people, for the whole of 2021/2022. This table is linked to my DimDate table. The Year slicer is from DimDate. When I put this info into a table, however, it's not showing me the targets for either year. Previously, before I added 2022 to the table, I could filter down by year, qtr and month without an issue.
This is how the table looks:
Sales Person is also linked. The Target col is the Value col from above which is no longer populating. The % Achieved is a measure:
Solved! Go to Solution.
Never mind, I was clearly having a moment!
When I appended 2021 to 2022, the month col switched from Date to Any, hence the lack of figures. So for anyone else who may experience this -- double check the data is stored as a date!
Never mind, I was clearly having a moment!
When I appended 2021 to 2022, the month col switched from Date to Any, hence the lack of figures. So for anyone else who may experience this -- double check the data is stored as a date!
Check out the March 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
93 | |
64 | |
56 | |
46 | |
45 |