Forum Discussion
Report View display data differently from Data View and Power Query
Hi Eiseln ,
You could add an index column in the query editor. Then sort this column by index in the data tab.
Hi Mariusz,
Thank you for the response. The issue was the Details3 column sort was different from my Data view and Query view sort. I wonder if I have clicked something accidentally as a learner for Power BI. I cannot correct the sort even if I user a custom sort, this will be exported as a CSV file.
My Data and Query View (Correct) Report View
Less Add: Adjuested Balance
Payments Payments
Adjusments Adjustments
Add: Add Adjusted Balance Less
Monthly Recurring Rate Less: Advance Payment:
Add: 12% VAT Add: 12% VAT
Total Monthly Recurring Rate
Less: Advance Payment Total
Hi Eiseln ,
You could add an index column in the query editor. Then sort this column by index in the data tab.