I've got a Power BI report querying a table from an Excel workbook stored in SharePoint Online.
One of the steps in my Power Query is to set the Data Type of several columns to Percentage. (They contain values from 0 to 1, with some cells blank)
When I run the query and go into the Power BI Desktop Report editor, I see my columns listed in the field selector on the right. For some reason, all of the columns that I had formatted as Data Type of Percentage now show up as "Sum of" fields, with a grayed out Σ character next to each field name.
I've never paid attention to the Sum Of character before, but for some reason I think it's interfering with my ability to use that field value as an input for conditional formatting rules I'm trying to create.
Is there a reason these don't come through as simple values, but instead are Sum Of values?