Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @Skemaz
You can try pivoting the column with the Don't aggregate option.
Hi @Skemaz
You can try pivoting the column with the Don't aggregate option.
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.
@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?
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |