Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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