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 ...
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.    

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

       

      • Pragati11's avatar
        Pragati11
        Super User
        5 years ago

        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