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:

     

     

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.?

  • Tahreem24's avatar
    Tahreem24
    Super User
    2 years ago

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

     

     

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

      Looks good. I am not interested in sum of population. Rather, population by year.