Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
I have some data which is not in the best format which I would like to display on a single graph over time however Power BI seems to be struglering to show it more than a single straight line.
Can any body please offer some advice on how I can reformat using PowerQuery this so its useable in a repeatble way as this comes from a dynamic data source ?
NB The first row is how the data is imported and the yellow colums are the one I want to use, the second is an example of where I tried to tidy it up and use it
Thanks
Terran
Solved! Go to Solution.
A very simple way to transform would be
Load the table into PQ without headers i.e. your headers will be Column1, Column2...
Transpose
Select first column, right click and remove all duplicates
Transpose
Promote headers
Below is the code which gets generated
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
#"Transposed Table" = Table.Transpose(Source),
#"Removed Duplicates" = Table.Distinct(#"Transposed Table", {"Column1"}),
#"Transposed Table1" = Table.Transpose(#"Removed Duplicates"),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table1", [PromoteAllScalars=true])
in
#"Promoted Headers"
Thanks I will give this a go and come back to this thread.
T
A very simple way to transform would be
Load the table into PQ without headers i.e. your headers will be Column1, Column2...
Transpose
Select first column, right click and remove all duplicates
Transpose
Promote headers
Below is the code which gets generated
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
#"Transposed Table" = Table.Transpose(Source),
#"Removed Duplicates" = Table.Distinct(#"Transposed Table", {"Column1"}),
#"Transposed Table1" = Table.Transpose(#"Removed Duplicates"),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table1", [PromoteAllScalars=true])
in
#"Promoted Headers"