March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
Here is the Desktop Dropdown working just fine
Yet when I publish the matrix to the online service this is what I get
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.
Solved! Go to Solution.
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.
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?
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.
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.
@RenuKshirsagar Hey,
No bookmarks unfortunately.
On my Desktop App.
This is how it looks like on the Online Report.
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:
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
40 | |
26 | |
17 | |
11 | |
10 |
User | Count |
---|---|
58 | |
52 | |
23 | |
14 | |
11 |