Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |