cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Make one column the Heading for other columns

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
Highlighted
Super User II
Super User II

Re: Make one column the Heading for other columns

@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!




Highlighted
Advocate II
Advocate II

Re: Make one column the Heading for other columns

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.
Highlighted
Advocate II
Advocate II

Re: Make one column the Heading for other columns

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.
Highlighted
Community Champion
Community Champion

Re: Make one column the Heading for other columns

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

Highlighted
Advocate II
Advocate II

Re: Make one column the Heading for other columns

Hi Bhavesh
Thanks for the sugestion.
I'll try to do it when I get back to my computer.
Regards, Mark.
Highlighted
Advocate II
Advocate II

Re: Make one column the Heading for other columns

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.

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors