Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I've used Power BI quite a bit lately with a SSAS cube and some Sql Server queries and created many visualiations. I am still fairly new to this though and cannot figure this out.
I imported a very simple Excel spreadsheet. 3 columns: period, actual, goal. I tried to make a line and stacked column chart. However, it keeps using the aggregations (that don't make sense). It is using a count of the goal and count of the actual and not the value from the spreadsheet.
When I go into the query, I see no place to change how/if a column is summarized. I know how to do this in PowerPivot.
Beyond that, I have no idea why it would do any aggregations since I am using all fields in the dataset and aggregation is not needed/appropriate.
When I click on the column under "Column values" it shows "Count of Actual" and the only options are "Remove Field", "Count (Distinct), and "Count". How do I kjust get the value?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |