Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
ccsnet
Frequent Visitor

Changing Data To Make It Usable For A Graph

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

 

Capture.PNG

 

Thanks

Terran

1 ACCEPTED SOLUTION
Vijay_A_Verma
Super User
Super User

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"

 

View solution in original post

2 REPLIES 2
ccsnet
Frequent Visitor

Thanks I will give this a go and come back to this thread.

 

T

Vijay_A_Verma
Super User
Super User

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"

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors