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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
KellyM82
New Member

Line Graph showing data where there shouldn't be any

Hi there,

 

I'm trying to build a trend graph over time to show the development curve in the number of applications received through a year.


For the y-axis I have a DAX measure that is giving a distinct count of the unique IDs. For the x-axis, I have the month names, which I have added in through an index table as I want the month names in a specific order. This table is joined to the data table through a date field. I've then added in a legend that splits out the different years. I'm expecting to see four curves and then just one data point for the current year as we're in the first month of counting but the graph is showing a cumulative total for this year against all months, per screenshot below (solid line at the bottom is the current year).

KellyM82_1-1698419385104.png

 

I can't work out where I'm going wrong, any ideas?

Thanks 

3 REPLIES 3
KellyM82
New Member

Really sorry @Ritaf1983 I don't know how to do that.

Hi @KellyM82 

Save it in onedrive and share the link.

Ritaf1983
Super User
Super User

Hi @KellyM82 
Please share a link to dummy pbix to work with

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.