Forum Discussion

Whitewater100's avatar
Whitewater100
Solution Sage
3 years ago

Shifting Rows up in Paginated Report

Hello Community: I have a confidential paginated report and I have remade the look in excel. Essentially I am asking how I can move up rows with information in High and Low columns to appear as the top rows for their index. We had to use a Python Script in the Power BI report to do this and I am using the Query Designer to bring in the Data set and the fields needed and that is working fine. I have attached an example of what it looks like (Dummy Data) and what the required result would look like. Thank you for any input on how to fix this issue!https://docs.google.com/spreadsheets/d/1UFtBRxHaozDo1lYUHUCDuoJy8FE3QZtH/edit?usp=share_link&ouid=107858444427060984721&rtpof=true&sd=true 

1 Reply

  • Does it have to have data in both columns or could you sort by High inside the section?