Forum Discussion

Sujit-TN's avatar
Sujit-TN
Regular Visitor
2 years ago
Solved

Report on Power BI Desktop

When download timeseries data to the report the dataset apperas as sum. But I need the count by year. Exapmle, population data from 2010 to 2022 by county.
Tutorial Requests
  • Tahreem24's avatar
    Tahreem24
    2 years ago

    Sujit-TN Simple by taking the required fields like this:

     

     

Sujit-TN's avatar
Sujit-TN
Regular Visitor
2 years ago

Here is one dataset as a sample.

Anderson201075129
Bedford201045058
Benton201016489
Bledsoe201012876
Blount2010123010
Bradley201098963
Campbell201040716
Cannon201013801
Anderson201175224
Bedford201145503
Benton201116429
Bledsoe201112854
Blount2011123899
Bradley2011100063
Campbell201140529
Cannon201113743
Anderson201275418
Bedford201245571
Benton201216372
Bledsoe201212786
Blount2012124174
Bradley2012101140
Campbell201240433
Cannon201213817
  • Tahreem24's avatar
    Tahreem24
    Super User
    2 years ago

    Sujit-TN Thanks for sharing the sample data. Please also add your expected output.

     

  • Sujit-TN's avatar
    Sujit-TN
    Regular Visitor
    2 years ago

    Report should contain population by county and year in slicer. Also, population by county and year in TN county map.

    • Tahreem24's avatar
      Tahreem24
      Super User
      2 years ago

      Sujit-TN I think you misunderstood my question. Add the Expected output column in your input table. So I can help you out with your query.

       

       

      • Sujit-TN's avatar
        Sujit-TN
        Regular Visitor
        2 years ago

        Did you get the inputset? In output: Population in y-axis and location in x-axis in the bar chart. Year in slicer. 

        Does it help.?