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,
I would like to extract the individual rows which are from 1-11 (and they keep on repeating) into 11 columns with their respective values.
Thanks,
Modasher.
Solved! Go to Solution.
Hi,
Please try to add an index column first.
Then try to create this calculated column:
Group = ROUNDUP('Table'[Index]/11,0)
Choose matrix visual, it shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto
Hi,
Please try to add an index column first.
Then try to create this calculated column:
Group = ROUNDUP('Table'[Index]/11,0)
Choose matrix visual, it shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto
@Anonymous ,
Please see if this can help
https://radacad.com/pivot-and-unpivot-with-power-bi
Refer, if this code can help
https://docs.microsoft.com/en-us/powerquery-m/table-pivot
Hi @Anonymous
Do you mean you want to pivot the every 11 rows to a table with 11 columns? Use Power Query to pivot it.
#1 add a custom column - Table.AddColumn(your last step, "Custom", each Number.IntegerDivide([Column Index]-1,11))
#2 remove the index column - Table.SelectColumns(#"Added Custom",{"Custom", "display_name","value"})
#3 pivot the table - Table.Pivot(#"Removed Other Columns", List.Distinct(#"Removed Other Columns"[display_name]), "display_name", "value")
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |