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

13 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    2 years ago

    Sujit-TN Could you share the dummy input data and expected output in order to understand your query.

  • 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
    • 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

    How can I attachinput dataset from my computer ? I am concern about security.

    • Tahreem24's avatar
      Tahreem24
      Super User
      2 years ago

      Sujit-TN I am not at all interested in your original data. I clearly mentioned "Sample" word in my first reply.

       

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

    If I click year in slicer can I get the output for that year?