cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
quantran
Frequent Visitor

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 NameDescriptionExample
Date FieldHas the field to calculate the years
Have 2019, 2020, 2021, and 2022 data
1/1/2019, 1/2/2019, 1/3/2019
New York CountyHas the counties for New York
Does not have Statewide
Central, Hudson Valley, Long Island
Count FieldThis field has a value for all rows in the report so that all rows are counted 

 

1 ACCEPTED SOLUTION
quantran
Frequent Visitor

2 REPLIES 2
quantran
Frequent Visitor

quantran
Frequent Visitor

quantran_0-1680097635018.png

 

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors