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
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!
Solved! Go to Solution.
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.
Ok. I'll try and update. Thank you!
Thank you. It worked!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
65 | |
61 | |
21 | |
18 | |
12 |