Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Here are the calculations for the opened and closed values.
Are you sure you are using the correct date column from the calendar table and note one from the data table?
@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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
104 | |
70 | |
67 | |
55 | |
41 |
User | Count |
---|---|
156 | |
83 | |
66 | |
64 | |
61 |