Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Thanks.
Solved! Go to Solution.
@Anonymous ,
Power bi will automatically summarize the number value once connecting to data source. You can click Modeling-> select "Don't Summarize" as below:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
Power bi will automatically summarize the number value once connecting to data source. You can click Modeling-> select "Don't Summarize" as below:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |