Bug on auto-refresh for visual formatting?

[charleshale]

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.

[charleshale]

@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

[Pragati11]

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

[charleshale]

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

[Pragati11]

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

[charleshale]

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

[Pragati11]

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

[Pragati11]

Hi @charleshale ,

What version of Power BI Desktop are you using in which you are seeing these issues?

Thanks,

Pragati

[charleshale · Accepted 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.