Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to Solution.
@Sujit-TN Simple by taking the required fields like this:
If I click year in slicer can I get the output for that year?
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
County Year and population in the input set.
How can I attachinput dataset from my computer ? I am concern about security.
@Sujit-TN I am not at all interested in your original data. I clearly mentioned "Sample" word in my first reply.
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 |
Report should contain population by county and year in slicer. Also, population by county and year in TN county map.
@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.
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.?
@Sujit-TN Simple by taking the required fields like this:
Looks good. I am not interested in sum of population. Rather, population by year.
@Sujit-TN Thanks for sharing the sample data. Please also add your expected output.
@Sujit-TN Could you share the dummy input data and expected output in order to understand your query.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |