Filter only affects legend partly

AnniekH96 — Fri, 09 Jul 2021 11:35:17 GMT

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 ?

Re: Filter only affects legend partly

Stachu — Sat, 10 Jul 2021 11:19:12 GMT

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).

Column1	Column2
A	1
B	2.5

topic Re: Filter only affects legend partly in DAX Commands and Tips

Filter only affects legend partly

Re: Filter only affects legend partly