Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Eiseln
Frequent Visitor

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!

 

Report View.PNGQuery View.PNGData View.PNG

1 ACCEPTED SOLUTION

Hi @Eiseln ,

 

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

2-1.PNG

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

5 REPLIES 5
Mariusz
Community Champion
Community Champion

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

 

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.

2-1.PNG

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

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

 

Eiseln
Frequent Visitor

Thank you. It worked!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors