...
Select → SalesReport → Edit button.
7. The Query editor table will open. Power BI Desktop also includes Query Editor, which opens in a separate window. In Query Editor, you can build queries and transform data, then load that refined data model into Power BI Desktop, and create reports.
Select and filter what data to show in the Power Bi report by selecting or deleting columns and applying required filters
8. Once you have the required data from Query Editor → Close & Apply
There are three views in Power BI Desktop: Report view, Data view, and Relationships view. Power BI Desktop also includes Query Editor, which opens in a separate window. In Query Editor, you can build queries and transform data, then load that refined data model into Power BI Desktop, and create reports.
The following screen shows the three view icons along the left of Power BI Desktop: Report, Data, and Relationships, from top to bottom. The currently displayed view is indicated by the yellow bar along the left. In this case, Report view is currently displayed. You can change views by selecting any of those three icons.
In Report view the data will populate into a column on the right called fields → Select what data you want to see in the report by selecting or dragging the fields in the order you wish for these to display.
Example Report →
OrderNo → Customer → Dispatch_Suburb → Dispatch_Post_Code → Order_Amount_ExTax → Order_Amount_IncTax → Workflow_Dispatch_Status → Workflow_Job_Tracking_Status → Order_status
You can add columns and
With Power BI Desktop installed you’re ready to connect to data, shape data, and build reports (usually in that order).
...
If you click edit data before you load, then you can select your date filters. We suggest you filter by "Invoice date" or "Accepted date"
TIPS for using Power Bi
Filtering Date/Time combination in Query Editor
Change organization your connected to
...