Forum Discussion
Solved
Statewide With Counties In Same Bar Chart
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 |
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
2 Replies
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