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

Anonymous's avatar
Anonymous
Not applicable
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