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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
guh950
Microsoft Employee
Microsoft Employee

Two visuals with same values and filtering settings show different results

I have two visuals using the same values, and filtering settings. The only thing that's different are that the two visuals are on two different pages. I was trying to find a way to debug this, and to see if I can get this resolved.

 

Both visuals are pulling from the same exact data, so it's not a data modeling issue. The data table has a "Total Reviews" and "Total Questions" data, which is being visualized on two separate tabs:

 

page1:

guh950_1-1636568105093.png

 

 

page2:

guh950_0-1636568049050.png

 

You'll notice that page2 numbers are down versus the page1 numbers. Also, I noticed the barchart for question volume for page2 is also different than the question volume for page1.

 

The underlying data for both of these visuals are the same exact data, so it's got to be a filtering issue at the page level. Moreover, when I look at the filters affecting each visual, and it comes up exactly the same for all visuals including the previous screenshots: (for simplicity, I did one screenshot here, but the other ones look exactly the same as this one)

 

guh950_2-1636568241856.png

page1 filters:

guh950_3-1636568316952.png

page2 filters:

 

guh950_4-1636568364155.png

 

I'm also looking at the Data/Drill tab, edit interactions, and am not finding any special filtering settings, I do feel stuck on what could be causing this issue. I'm almost certain that it's a page-level filter, but I don't know how else to debug it if the filtering looks the exact same for both, and I've only come across this issue with the most recent refresh (which means it wasn't an issue for 6 months until now).

1 ACCEPTED SOLUTION

Adjust the layer order and display the slicer first to see if you can see the contents of the slicer.

View solution in original post

5 REPLIES 5
mhossain
Solution Sage
Solution Sage

@guh950 

Did you try already the 'Reset filter' option ?

mhossain_0-1636575725427.png

 

guh950
Microsoft Employee
Microsoft Employee

@mhossain  I have the reset filters disabled on the online version:

 

guh950_0-1636580637145.png

 

@guh950 

 

Looks strange, see the 'Selection' pane (under view in toolbar), see if anything hidden which is causing this issue.

 

If you copy all visuals Cntrl+A page1 and paste to a completely new page, does this brings the same number?

guh950
Microsoft Employee
Microsoft Employee

@mhossain 

 

When I copy the first visual into the second, I see that it looks like the second page, so its got to be a filter setting.

I'm seeing one layer item that is hidden, a slicer, but when I show it, I do not see where it is on the page at all.

guh950_0-1636582386063.png

 

Adjust the layer order and display the slicer first to see if you can see the contents of the slicer.

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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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