Why does it take PBI Desktop upwards of 6 seconds to change the number format of a single measure? That's way too long, and makes formatting of reports excruciating. Is it because it also has to update all the visuals? Is there a way to set visual updates to manual? I find this aspect of PBI very frustrating almost to the point where I'd rather author my reports in Excel. I'm an intermediate PBI user and an expert Excel user... in Excel, a similar action done to a pivot table takes a fraction of a second. In addition, there's an option for pivot tables to "defer layout update" if you're having performance issues (which I have almost never had to use).
To make things worse, it seems that PBI Desktop can only make 1 adjustment to a number format at a time; e.g. change from 'General' to 'Percentage' ... wait 6 seconds ... THEN change number of decimals displayed (can't do both simultaneously) ... wait 6 more seconds ... move on to the next measure. It's crazy time-consuming when building out a medium to large report with dozens or hundreds of measures.
For reference: my report has 6 fact tables, each with as few as 1,000 or as many as 275,000 rows. I also have 9 dimensions with as few as 10 rows or as many as 17,000 rows. My model is set up as a star schema (no snowflake). The report itself has 26 tabs and upwards of 150 visuals and around 375 measures of varying complexity. Many of the measures are intermediate calculations that aren't explicitly used in the visuals.
Thanks,
MC
