Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
Hi. Small issue: Visuals in a particular PowerBI file of mine do not automatically refresh to show formatting changes. Manually clicking the Refresh menu bar works.....but not automatic refresh (see below for an example of a screenshot where the visual has not automatically refreshed). Is this a setting / feature or a bug?
This same file also has another odd behavior that might be related: when I set a column to Summarize as below...
....The column should show with a Summarize sigma sign and autosum when put into a visual but it is not.
Methinks I have missed or accidentally changed a setting somewhere on how data is handled. Any advice? Thank you.
Solved! Go to Solution.
I've figured out the Summarization failure. It is a known bug we have encountered several times where values fail to get recognized as values even though they are shown as such throughout the data lineage. The only solution that works is in DAX to add a column with an express INT() or VALUE() of the column of values that fails to get treated as such.
@Pragati11 Latest version: 2.93.981.0 64-bit (May 2021)
Seeing the formatting issue in Table and Matrix visualizations
And seeing the Summarize failing on Data/Column Tools/Summarization button as well as on fields pane -- that's where the snapshots are from
Hi @charleshale ,
What is the type of datasource you are using?
I don't see these issues at my end with the latest Power BI Desktop May 2021 version.
Thanks,
Pragati
Excel and CSVs. It doesnt appear to be a datasource issue because everything else other than formatting refreshes and redoing the file from scratch doesnt have the problems. Feels more like a bug or a setting I accidentally changed somewhere
Hi @charleshale ,
As far I know there is no setting to disable Summarisation in Power BI until and unless you do it under column tools.
Is the datatype of AMOUNT column numeric?
I don't see this issue at my end.
Thanks,
Pragati
Yes - source data numeric. It's strange. I can't reproduce the issue in other files either, which leads me to think it's some kind of bug with the new release -- perhaps related to using tabular editor -- which is when I think the issue started. Must have corrupted the file somehow
HI @charleshale,
I am confident it is not a bug in latest release as I don't see this issue at my end.
Could be something with the file corruption.
Thanks,
Pragati
Hi @charleshale ,
What version of Power BI Desktop are you using in which you are seeing these issues?
Thanks,
Pragati
I've figured out the Summarization failure. It is a known bug we have encountered several times where values fail to get recognized as values even though they are shown as such throughout the data lineage. The only solution that works is in DAX to add a column with an express INT() or VALUE() of the column of values that fails to get treated as such.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
110 | |
97 | |
71 | |
67 |