Report on Power BI Desktop

[Sujit-TN]

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.

[Sujit-TN]

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

[v-cgao-msft]

Hi @Sujit-TN 

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

Yes, it is.
If Tahreem's answer was helpful, don't forget to mark it as an soluntion~🤗

How to Get Your Question Answered Quickly

Best Regards,
Gao
Community Support Team

[Sujit-TN]

County Year and population in the input set.

[Sujit-TN]

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

[Tahreem24]

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

[Sujit-TN]

Here is one dataset as a sample.

Anderson	2010	75129
Bedford	2010	45058
Benton	2010	16489
Bledsoe	2010	12876
Blount	2010	123010
Bradley	2010	98963
Campbell	2010	40716
Cannon	2010	13801

Anderson	2011	75224
Bedford	2011	45503
Benton	2011	16429
Bledsoe	2011	12854
Blount	2011	123899
Bradley	2011	100063
Campbell	2011	40529
Cannon	2011	13743

Anderson	2012	75418
Bedford	2012	45571
Benton	2012	16372
Bledsoe	2012	12786
Blount	2012	124174
Bradley	2012	101140
Campbell	2012	40433
Cannon	2012	13817

[Sujit-TN]

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

[Tahreem24]

@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]

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 · Accepted solution]

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

[Sujit-TN]

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

[Tahreem24]

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

[Tahreem24]

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