Karachi Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

how to create hirerarchy visual for country wise (parent) + year wise (child) population data

  • 1.  how to create hirerarchy visual for country wise (parent) + year wise (child) population data

    Posted Jun 04, 2021 04:22 AM
    Edited by Ahmed Haroon Jun 04, 2021 05:46 AM

    hi all,

    want to create a Table type visual for country+year wise population data, please help how i can do it. below are sample data, desired output and sample screenshot.

    sample data ( actual Excel file contains columns like: Country   2012   2013   2014   2015 ...   population figues under years columns, i have Unpivot to have data in below format ) :

    Country        Year         Population

    Brazil           2012              100010

    Brazil           2013              100020

    Brazil           2014              100030

    Canada       2012               200010

    Canada       2013               200020

    Canada       2014               200030

    desired output  (also refer to below screenshot upper portion which show in Table view on left and Chart on right):

    Country       Population     Population Prvs Yr

    Brazil                 300060

      2012               100010

      2013               100020                       100010

      2014               100030                       100020

    Canada             600060

      2012               200010

      2013               200020                       200010

      2014               200030                       200020

    Total                 900120


    screenshot here (upper portion)

    regards

    ------------------------------
    Ahmed Haroon
    Developer
    ------------------------------