I have a dataset for Australia for various variables. The data is at suburb label with data on states as well. I have created a clustered bar chart in powerbi for all the variables for a selected suburb. I want to add bars for average values in overall Australia and the state of the selected suburb as well. How do i do this in powerbi?
SubUrb | State| Age under 18 | age 18-60 | age 60+
Thanks so much! But, I wanted the values for the state and the country as an additional bar in the clustered bar chart. On top of that, I want the legend to have the selected suburb, state and Australia as legend items. CHeers!