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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
GunnerJ
Post Patron
Post Patron

Data not appearing the same between charts

I have a 12 month view chart that shows how many service orders were opened and closed within a given month. That chart shows the correct values. I then have two seperate Treemaps that show the opend and closed values of all service order types for a filtered time period. The open chart shows the correct values but the closed chart just seems to repeat the open chart. I'm unsure why this is the case since in the other chart the values are showing correctly. In the picture below the top graph in May 2019 shows the time period for the tree maps. The largest square "DISC" are the values in question. 240 is correct for the open values but for DISC in the closed map (bottom) I'd expect to see 249.

 

Closed Service Orders.PNG

 

Here are the calculations for the opened and closed values. 

Opened = DISTINCTCOUNT(Workflow[BI_SO_NBR])
Closed = CALCULATE([Opened], USERELATIONSHIP(Workflow[BI_CLOSE_DT],Dates[Date]))
 
Any help would be appreciated. I'm sure I'm just overlooking something simple. Thank you!
2 REPLIES 2
MattAllington
Community Champion
Community Champion

Are you sure you are using the correct date column from the calendar table and note one from the data table?



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

@MattAllington  you were right... how embarrassing. I knew I must have overlooked something.

 

Thank you for the quick reply. 


@MattAllington wrote:

Are you sure you are using the correct date column from the calendar table and note one from the data table?


 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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