Forum Discussion
Report View display data differently from Data View and Power Query
Hi! Good day!, I just used the Power BI for our payment template. But I do encountered an issue in 1 column of my table which is Details3 column. The power query and the data view are both similar in all columns except for the Details3 column. Kindly suggest what seems to be the issue. Thank you very much!
Hi Eiseln ,
You could add an index column in the query editor. Then sort this column by index in the data tab.
5 Replies
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.
