Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
smather
Helper III
Helper III

Targets Not Showing

I have a table that's like this: 

 

 

Sales PersonMonthValue
CJ01/01/2021£100
CJ01/01/2022£200
CJ01/02/2021£150
CJ01/02/2022£250
CJ01/03/2021£200
CJ01/03/2022£250
CJ01/04/2021£500
CJ01/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:

 

smather_0-1643716581780.png

 

Sales Person is also linked. The Target col is the Value col from above which is no longer populating. The % Achieved is a measure: 

 

% Acheived D365 = DIVIDE([Total Sales D365],CALCULATE(SUM('TARGETS 2022'[Value])),0)
 
(Targets 2022 has had the targets from 2021 appended to it in the query editor).  I've also got the same set up in another table for GP, which is also displaying the same behaviour as the turnover table. 
 
I'm assuming I need to update my measures, but with everything having the correct relationships (as far as I can tell) I'm not sure what I should do, any help would be amazing.
1 ACCEPTED SOLUTION
smather
Helper III
Helper III

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!

View solution in original post

1 REPLY 1
smather
Helper III
Helper III

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!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors