Forum Discussion

charleshale's avatar
charleshale
Continued Contributor
5 years ago
Solved

Bug on auto-refresh for visual formatting?

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.

 

 

Need Help
  • charleshale's avatar
    charleshale
    5 years ago

    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.    

8 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi charleshale ,

     

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

     

    Thanks,

    Pragati

    • charleshale's avatar
      charleshale
      Continued Contributor
      5 years ago

      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.    

  • charleshale's avatar
    charleshale
    Continued Contributor
    5 years ago

    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's avatar
      Pragati11
      Super User
      5 years ago

      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's avatar
        charleshale
        Continued Contributor
        5 years ago

        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