Headcount by month

[rosscortb]

Hello

I have a headcount page with a month slicer which shows me the month headcount by sector.

What I want is a graph with a headcount by month so April 2000, May 2500 but as its got a month slicer on the page it defaults to just what month that is selected.

I managed to achieve what I wanted on a new page, see screen shot, as there is no slicer on here.

Do I need to do a measure, something like, Measure = CALCULATE(COUNT('DB Headcount'[Level 3], FILTER('Month','Month'[Month])))

Thanks

Ross

[v-juanli-msft · Accepted solution]

Hi @rosscortb

You could take chirayuw's suggestion into consideration,after setting interaction for these visual, filtering a month doesn't reflect the chart where it shows the month headcount by sector.

Best Regards

maggie

[Anonymous]

To be honest you don't need a separate page. you can disable other visuals interacting with the graph. refer to below link

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions