I have a bar chart that has statewide data as well as counties (see image below). Following are the fields that I used for this image. The New York County field does not have Statewide.
I was wondering what is the best way to set this up?
Thank you.
Field Name | Description | Example |
Date Field | Has the field to calculate the years Have 2019, 2020, 2021, and 2022 data | 1/1/2019, 1/2/2019, 1/3/2019 |
New York County | Has the counties for New York Does not have Statewide | Central, Hudson Valley, Long Island |
Count Field | This field has a value for all rows in the report so that all rows are counted |
Solved! Go to Solution.
I was able to do this by following this video on how to add Totals:
Bonus How to add Totals to a bar chart visualizations using DAX
I was able to do this by following this video on how to add Totals:
Bonus How to add Totals to a bar chart visualizations using DAX
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
131 | |
81 | |
65 | |
61 | |
55 |
User | Count |
---|---|
199 | |
104 | |
88 | |
79 | |
77 |