Forum Discussion

schmid23's avatar
schmid23
Regular Visitor
4 years ago
Solved

Evolution Graph

I am trying to create a graph of population evolution for different cities, but I don't know how to create it the way I have structured the data. I have two tables a first table (table1) with the ci...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi schmid23 ,

     

    I created two tables for testing.

    Table1.

    Table2.

    Relationships.

    If you want to minimize the impact on the original model. You can make a copy of Table1 in PQ and rename it as Table3. Then select the table3 [Municipio] column, right click and click to unpivot other columns. Closed and

    apply.

    Relationships. 

    Please create a new line chart.

    The PBIX file is attached for reference.

     

    Best Regards,
    Community Support Team_Gao

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

KerKol's avatar
KerKol
Icon for Power Participant rankPower Participant
4 years ago

You'll need to unpivot your data for Table 2 in Power Query

So that you can then drag the dates field into the Axis

 

How to Unpivot in Excel with Power Query + Video Tutorial (excelcampus.com)

 

Unpivot And Pivot Basics In Power BI - Query Editor Review - Enterprise DNA

 

will then help to have fact and dimension tables, with a one-to-many relationship from dimension table to fact table:

Basics of Modeling in Power BI: What is a Dimension Table and Why Say No to a Single Big Table - RADACAD

Power BI Fact and Dimension Tables | SQL Spreads