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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Telenar
Frequent Visitor

Same Visiaul, Same Filter, Different results

So, not sure what is happening here, but I've beat my head against this for hours with no success.

 

All Three.png

 

 

 

 

 

So, here is what's going on. The first graph is the original. The numbers seem to be correct, align and total up with the Total Value displayed elsewhere on the page, and seem to capture all the required data for the filters being used. Blank in this case indicates that a category wasn't assigned, but there is still a value there. Also note that there is a scroll bar on the first graph, as there are more categories below.

 

So, here's where it get's weird. Graph two is a simple copy and paste.  Nothing is changed at all. Checked all the filters. They match, which makes sense since it's just a copy and paste of the first visual. But if you look at the numbers (especially the blank value) they are no longer the same. There are categories missing that should be there (checked the data manually). And the sum of the categories no longer matches up with the sum total at the top of the page.

 

On to the third graph. The third one was simply a recreation from scratch. Started with a blank visual and added in the filters and fields to match the first. This table matches the second but is still not showing the complete data.

 

These aren't difficult tables. There are only two fields and 4 filters. It's now making me really nervous that I can't trust other parts of the data. I really don't have time to go through and check every chart by hand to make sure they are correct, but I'm worried.

 

Any ideas to why this would be happening? 

1 ACCEPTED SOLUTION
Telenar
Frequent Visitor

OK so figured it out (should have gone just a little longer before posting), but for anyone who comes across this, here was the answer. 

 

On ther page there was also a date slicer. I didn't think anything of it as the date was obviously the same for all three graphs in question. Copy and Paste I figure would create an exact duplicate and hence my utter confusion at them not behaving the same. Turns out, not all properties are duplicated with a copy and paste. In this case it was the interactions that didn't carry over.  The slicer was set to not interact with the first graph (the correct behavior, but something I forgot about). Turns out, copy and paste does not carry over interaction settings. Changed it and everything works as intended now.

 

Lesson learned today, not everything copies over with a copy and paste. 

View solution in original post

1 REPLY 1
Telenar
Frequent Visitor

OK so figured it out (should have gone just a little longer before posting), but for anyone who comes across this, here was the answer. 

 

On ther page there was also a date slicer. I didn't think anything of it as the date was obviously the same for all three graphs in question. Copy and Paste I figure would create an exact duplicate and hence my utter confusion at them not behaving the same. Turns out, not all properties are duplicated with a copy and paste. In this case it was the interactions that didn't carry over.  The slicer was set to not interact with the first graph (the correct behavior, but something I forgot about). Turns out, copy and paste does not carry over interaction settings. Changed it and everything works as intended now.

 

Lesson learned today, not everything copies over with a copy and paste. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.