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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Chart showing incorrect month

hi guys ,

I have a data like below 

ProjectProj CodeCreation DateWon DateLost DateCreation FYCreation FY Month No.Creation MonthWon Fy Won  MonthWon FY Month No.Status
Proj1000126 March 201918 April 2019 2018-201912March2019-2020April1Won
Proj2000224 September 20191 october 2019 2019-20206September2019-2020October7Won

Now to i have to show total projects in different statuses over current fiscal year's months.So below are the measures i have used

This year won projects=

 
Var MaxFYYear=MAX('Pipeline Master'[Won FY]) //To give me current fiscal year.
Return
CALCULATE(DISTINCTCOUNT('Pipeline Master'[Pipeline Code]),FILTER('Pipeline Master','Pipeline Master'[Won FY]=MaxFYYear),'Pipeline Master'[Status (groups)]="Won")


Now when i am combining the above measure with "Won Month" column in a chart it shows "March" month too which is not even present in the data.Can you guys please help me why is it happening to me ?

1 ACCEPTED SOLUTION
technolog
Super User
Super User

From the data you've provided, it seems like you're trying to count the number of projects that have been won in the current fiscal year. The DAX measure you've written is designed to do just that.

However, the issue you're facing is that when you combine this measure with the "Won Month" column in a chart, it's showing "March" even though it's not present in the data.

The first thing that comes to mind is that there might be an issue with the way the data is being filtered or visualized. Here are a few things to consider:

- The data you've provided does have a "March" in the "Creation Month" column for Proj1. Even though this isn't the "Won Month", it's possible that there's some overlap or confusion in the way the data is being visualized. Ensure that the chart is strictly using the "Won Month" column and not any other month column.

 

- The FILTER function in your measure is filtering the data based on the fiscal year and the status. It's possible that there's other data in your 'Pipeline Master' table that has a "Won Month" of March but isn't shown in the sample you've provided. You might want to check the entire dataset to ensure there's no such entry.

 

- Another thing to consider is the way the months are sorted or visualized in the chart. Sometimes, visuals might have default sorting or grouping that can cause unexpected results. Ensure that the chart is sorted by the "Won FY Month No." column to get the months in the correct order.

 

- Lastly, it's always a good idea to check for any relationships or interactions with other tables or visuals in your Power BI report. Sometimes, slicers or other filters can cause unexpected behavior in visuals.

 

In summary, while your DAX measure seems correct for the task at hand, the issue might be with the way the data is visualized or with some unseen data in your table. Double-check the entire dataset, ensure the chart is using the right columns, and check for any other interactions in your report. Hope this helps!

View solution in original post

1 REPLY 1
technolog
Super User
Super User

From the data you've provided, it seems like you're trying to count the number of projects that have been won in the current fiscal year. The DAX measure you've written is designed to do just that.

However, the issue you're facing is that when you combine this measure with the "Won Month" column in a chart, it's showing "March" even though it's not present in the data.

The first thing that comes to mind is that there might be an issue with the way the data is being filtered or visualized. Here are a few things to consider:

- The data you've provided does have a "March" in the "Creation Month" column for Proj1. Even though this isn't the "Won Month", it's possible that there's some overlap or confusion in the way the data is being visualized. Ensure that the chart is strictly using the "Won Month" column and not any other month column.

 

- The FILTER function in your measure is filtering the data based on the fiscal year and the status. It's possible that there's other data in your 'Pipeline Master' table that has a "Won Month" of March but isn't shown in the sample you've provided. You might want to check the entire dataset to ensure there's no such entry.

 

- Another thing to consider is the way the months are sorted or visualized in the chart. Sometimes, visuals might have default sorting or grouping that can cause unexpected results. Ensure that the chart is sorted by the "Won FY Month No." column to get the months in the correct order.

 

- Lastly, it's always a good idea to check for any relationships or interactions with other tables or visuals in your Power BI report. Sometimes, slicers or other filters can cause unexpected behavior in visuals.

 

In summary, while your DAX measure seems correct for the task at hand, the issue might be with the way the data is visualized or with some unseen data in your table. Double-check the entire dataset, ensure the chart is using the right columns, and check for any other interactions in your report. Hope this helps!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.