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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

Matrix Row Not Showing

Here is the Desktop Dropdown working just fine

 

ptawil_0-1603294977458.png

 

Yet when I publish the matrix to the online service this is what I get

 

ptawil_1-1603295016083.png

 

 

There is no dropdown. It only works when I edit it online and save but once I publish again from my desktop app the proper functionality is gone.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

After fiddling around like an idiot I figured out that for whatever reason, resetting filters, slicers etc... to default (which honestly changed nothing as I didn't have any filters on in the first place) fixed it. If I had to guess what happened it's something to do with cache or an optimization in the service that didn't acknowledge the change in adding the row I guess.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

I've ran into this issue today. I tried resetting everything to default and republishing but online version is still not including the drop down for one specific line. Any updates on a solution?

Anonymous
Not applicable

After fiddling around like an idiot I figured out that for whatever reason, resetting filters, slicers etc... to default (which honestly changed nothing as I didn't have any filters on in the first place) fixed it. If I had to guess what happened it's something to do with cache or an optimization in the service that didn't acknowledge the change in adding the row I guess.

RenuKshirsagar
Advocate II
Advocate II

Hello @Anonymous ,  

 

Are there any bookmarks on your report page? If yes, then make sure you saved the correct state of the matrix i.e. in the lowest drilled-down form.

If this is not the case, then can you please provide screenshot of your report blurring the data and giving an overview of the report visuals and other components. 

 

If this information is useful, then kindly hit LIKE or promote this information as a solution in order to help other end users to find this solution.  

 

Thanks,  

Renu KS.

 

Anonymous
Not applicable

@RenuKshirsagar Hey,

 

No bookmarks unfortunately.

 

On my Desktop App.

 

tKOYRyvC4L.png

 

This is how it looks like on the Online Report.

 

3qi4vtZjYj.png

 

 

Lime = Retailer

Red = Store

Blue = Salesman

 

There are filters but they're just to remove unecessary retailers and I have refreshed my data so that's not the problem either.

 

On the online service heres the matrix when I click on the edit button:

ptawil_0-1603354156583.png

 

 

So the row is there, it just won't display. If I remove it and add it back it works as intended but whenever I will publish from the Desktop App it will remove it again which isn't helpful.

 

Another update: If I export the summarized data I do get the Name of the person but when I refresh my page after I edit I lose the Name drilldown.

 

I am very lost

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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