Report View display data differently from Data View and Power Query

[Eiseln]

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!

[Mariusz]

Hi @Eiseln 

Can you explain what is the issue that you have?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Eiseln]

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

[v-eachen-msft · Accepted solution]

Hi @Eiseln ,

You could add an index column in the query editor. Then sort this column by index in the data tab.

[Eiseln]

Ok. I'll try and update. Thank you!

[Eiseln]

Thank you. It worked!