Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
96 | |
92 | |
83 | |
69 |
User | Count |
---|---|
160 | |
125 | |
116 | |
110 | |
95 |