dominicgetdown
New Member
- Joined
- Nov 9, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hello, need some help with adding a Total Bar to a (clustered column) bar chart.
Set up (main table):
Fields: Company (x-axis) / Score (value) / Recording Date (slicer)
Creates a bar chart with the 'Company' on the x-axis, and have it set to average for 'Score'. The 'Recording Date' is used in my slicer to filter the chart based on date.
Need help with:
- Add a "Total Average" bar that is the total average of score, that shows on the same chart (on x-axis with 'Company'), and can still be filtered by the 'Recording Date' slicer
It appears a new table will be needed. Tried a couple things, but not working as intended. Anyone know the Dax to be able to set this up?
Thanks
Set up (main table):
Fields: Company (x-axis) / Score (value) / Recording Date (slicer)
Creates a bar chart with the 'Company' on the x-axis, and have it set to average for 'Score'. The 'Recording Date' is used in my slicer to filter the chart based on date.
Need help with:
- Add a "Total Average" bar that is the total average of score, that shows on the same chart (on x-axis with 'Company'), and can still be filtered by the 'Recording Date' slicer
It appears a new table will be needed. Tried a couple things, but not working as intended. Anyone know the Dax to be able to set this up?
Thanks