cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Unstructured Table

Hi Team,

 

Thank you so much for your help, now I have another query...

 

How can I work on Trend Analysis/Line chart in the below one.

 

screen.PNG

 

Thanks,

Kali

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: Unstructured Table

Hi Kalidass,

 

To create a trend chart, you have to unpivot the table.

Ex1.png

You will get this view and then use year and Value to build a trend line.

Ex2.png

Result:

Ex3.png

 



_______________
If I helped, please accept the solution and give kudos! 😀

View solution in original post

4 REPLIES 4
Highlighted
Solution Sage
Solution Sage

Re: Unstructured Table

Hi Kalidass,

 

To create a trend chart, you have to unpivot the table.

Ex1.png

You will get this view and then use year and Value to build a trend line.

Ex2.png

Result:

Ex3.png

 



_______________
If I helped, please accept the solution and give kudos! 😀

View solution in original post

Highlighted
Super User II
Super User II

Re: Unstructured Table

Hi @Kalidass ,

 

Before generating any trend/line chart, you will have to modify the structure of the data, so that you can have a DATE column on your x-axis on the chart.

For this what you can do is following:

  1. Go to Edit Query section.
  2. Naviagte to the data-set that you have shown below.
  3. Select all the date columns - 2020 to 2028.
  4. Go to Transform and Unpivot the selected columns.
  5. You will send up with following columns:
    • Markets
    • Keys
    • Attribute
    • Value
  6. Attribute column will have date values - 2020 to 2028. Rename this column to DATE or whatever you want.
  7. Now you can use this column to generate some trend chart.

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Highlighted
Super User IV
Super User IV

Re: Unstructured Table

@Kalidass 

Unpivot the data create tables/dimensions for the Market, Keys and year to create star schema model

https://radacad.com/pivot-and-unpivot-with-power-bi

 

Market = distinct(all(Table[Market]))

Keys= distinct(all(Table[Keys]))

Year= distinct(all(Table[Year])) //You will get after Unpivot

 

Join them back with table

Refer:https://docs.microsoft.com/en-us/power-bi/guidance/

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Community Support
Community Support

Re: Unstructured Table

Hi @Kalidass ,

 

Is this problem solved?


If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


If not, please let me know.

 


Best Regards,
Icey

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors