cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Skemaz
Advocate II
Advocate II

Make one column the Heading for other columns

Hi

If you check out the screen-shot below, what I want to do is have the column (highlighted below) to become the header for all the other columns.

The values in the highlighted column range from 1-13 for each horse. These are the section breaks of the race-course that each horse runs from start to finish.

Any suggestions will be greatly appreciated.

Thanks, Mark.

 

Picture1.png

 

 

1 ACCEPTED SOLUTION
BhaveshPatel
Community Champion
Community Champion

Hi    @Skemaz

 

You can try pivoting the column with the Don't aggregate option.

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

6 REPLIES 6
BhaveshPatel
Community Champion
Community Champion

Hi    @Skemaz

 

You can try pivoting the column with the Don't aggregate option.

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

Hi Bhavesh

Many thanks.

After doing what you suggested, I created seperate queries for each section using the original query as my source then removing the other sections and filtering out the null values.

After that I merged all the queries giving me a column for the horses and columns for the sections.

Many thanks for your solution.

Best regrads, Mark.

Hi Bhavesh
Thanks for the sugestion.
I'll try to do it when I get back to my computer.
Regards, Mark.
vanessafvg
Super User I
Super User I

@Skemaz Mark sorry i am not quite clear on what you asking can you demonstrate what the data should look like if it was as you want it to be?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi Vanessa
Thanks for your assistance.
What I want the resulting table to look like is for the Section numbers that recur 13 times for each horse in the column shown above to become the 1st row / header of the table.
The horse name would also be a column.
This will allow me to create a table visualizer where each horse has all 13 section times across the single row for each horse.
Sorry, I'm typing on my phone and couldn't draw a table for the above, so I hope that this explanation suffices.
Thank you very much for helping.
Best regards, Mark.

So my table would be.
HORSE NAME, S1, S2, S3, S4, S5, S6, S7, S8, S9, S10, S11, S12, S13
NAME, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13
I hope that helps.
Best regards, Mark.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors