Forum Discussion

Eiseln's avatar
Eiseln
Frequent Visitor
6 years ago
Solved

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...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Eiseln ,

     

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

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

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's avatar
    Eiseln
    Frequent Visitor
    6 years ago

    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's avatar
      v-eachen-msft
      Community Support
      6 years ago

      Hi Eiseln ,

       

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

       

      • Eiseln's avatar
        Eiseln
        Frequent Visitor
        6 years ago

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