Forum Discussion

AnniekH96's avatar
AnniekH96
Frequent Visitor
5 years ago

Filter only affects legend partly

Hi everyone,

 

I would like to make a visual in which I show the percentage of men and women in a team within in a company compared to the percentage of the company as a whole per age group.

 

I plan to use for this the clusterd bar chart with age in the axis, team in the legend, and number of people in the value section. 

 

Currently if I filter on Team A I would only see team A, and if I don't filter I get a bar for all the teams within the company. 

 

What do I need for this type of graph? A dax measure, grouping ? 

1 Reply

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

    Column1Column2
    A1
    B2.5