Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
101 | |
93 | |
69 |
User | Count |
---|---|
173 | |
135 | |
132 | |
101 | |
95 |