Forum Discussion
Kampua
4 years agoRegular Visitor
How to build a graph using given data?
New to PowerBI here be kind. I have a simle table with date on one cilumn and some values on another column, I need to plot a simple line graph. However PowerBI does not allow me to do so, it will on...
- Anonymous4 years ago
Hi Kampua ,
After reviewing your file, the data type settings are correct. In the Values field, select the aggregate type as Sum as shown below. Please find the details in the attachment.
Work with aggregates (sum, average, and so on) in Power BI
Option to choose "Don't Summarize" Missing. "Do not summarize" is not honored.
In a table, the column appears Do not summarize however for non-summary charts
Best Regards
Seanan
4 years agoSolution Supplier
Hi Kampua
If you click on your line chart, in the visualisation pane, click the drop down arrow next to Planned Quota in the Y-Axis and is there and option called don't summarise?
If not could you also check that your planned quota column is of the data type Whole Number.
Kampua
4 years agoRegular Visitor
There is no "don't summarise" option,
Yes it is whole number.