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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
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!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.