Forum Discussion
Two questions - header collapse and mid-refresh data changes
Hi all - two quick questions of issues I've been dealing with lately.
1) I have a matrix visual with "switch values to rows" turned on, several fields displaying, and a column that I've filtered to only one value. There's no data in the Rows section. Fairly regularly, I'll check the report and the header will have collapsed itself to the minimum possible width, making the visual unreadable. In the column headers option, I have "auto-size width" set to off, so they should always maintain the width that I've set. I drag the column back to where I want it, save, etc., and then I'll check later and it will have collapsed again.
2) I have a semantic model with a number of Kusto (KQL) queries in import mode. Occasionally, while a model refresh is in progress, the data from those queries in downstream reports in the Service will display incorrect values, then revert to their correct values once the refresh is completed.
As an example, the value was 305, a during the refresh it displayed in the reports as 288, then immediately once the refresh completed, it displayed as 305 again. During the refresh, if I run the actual Kusto query in ADE, it still returns correct results, so I'm not sure what it's displaying in the interim. The upstream data itself isn't changing during that period.
I crossposted the second question to the Service forum, but this one gets a lot more traffic. Any help on these two? Thanks!
Hi! RMDNA
To answer your 1st question that is a known limitation in matrix please read this Matrix Table resizing columns with Autosize column... - Microsoft Fabric Community
To overcome this you can add a measure to add spaces like - ColumnWidth = REPT("0", 16)
For 2nd I don't have the idea, ideally it should not change until the refresh is completed.
2 Replies
- AnkitKukrejaSuper User
Hi! RMDNA
To answer your 1st question that is a known limitation in matrix please read this Matrix Table resizing columns with Autosize column... - Microsoft Fabric Community
To overcome this you can add a measure to add spaces like - ColumnWidth = REPT("0", 16)
For 2nd I don't have the idea, ideally it should not change until the refresh is completed.
- RMDNASolution Sage
Thanks for finding that, AnkitKukreja. Not a satisfying answer, but I guess that's where things stand at the moment.
I got a response to my second question on the Service forums, so I'll consider this completed.