Filter one column in a matrix

[Sk1_2]

Hello, 

How do I filter one column in a matrix? For example, I want to display the remainder of 2024 and January 2025. But the January column is only displaying 2024 numbers. How can I only filter the January column for the year 2025? 

I can use a slicer but my manager wants it to be displayed. Any tips will be super helpful. 

Thank you in advance

[v-jiewu-msft · Accepted solution]

Hi @Sk1_2 ,

Based on the description, try to create the new measure.

StaffCountOtherMonths = 
var _month = SELECTEDVALUE('Table'[Month name])
RETURN
IF(_month <> "Jan-2024", SUM('Table'[staff count]))

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Sk1_2 No, you would have to write a measure to do that kind of thing. Hard to really say though as there is extremely little information provided.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Sk1_2]

@Greg_Deckler Thank you. I figured so. Please see sample data below and expected output. I would like to filter the month of January to only show data for 2025. Currently the month of January is displaying 2024

	October 2024	November 2024	December 2024	January 2025
Blue	5	5	5	10
Green	6	6	6	15
Yellow	3	3	3	7

Row: Project

Column: Month

Values: staff count

Thank You in advance,

[Greg_Deckler]

@Sk1_2 So what is the source data for this as I assume this is the output you want?

[Sk1_2]

@Greg_Deckler Its SQL Server Database 

[Greg_Deckler]

@Sk1_2 OK, I get that, but what does the table look like? Like this?

Column1, Column2, Column3

blue, 1/1/2024, 5

blue, 1/1/2025, 10

blue, 10/1/2024, 11

blue, 11/12/2024, 6

green, 1/1/2024, 5

green 1/23/2025, 7

These kinds of things really matter and it's not fun to guess or hand type a bunch of data.

[Sk1_2]

@Greg_Deckler  Yes, thats what it looks like 

Column1, Column2, Column3

blue, 1/1/2024, 5

blue, 1/1/2025, 10

blue, 10/1/2024, 11

blue, 11/12/2024, 6

green, 1/1/2024, 5

green 1/23/2025, 7

[Ashish_Mathur]

Hi,

I do not understand.  Create a Calendar Table with a relationship to the Fact Table.  Create calculated columns of Year, Month name and Month number in the Calendar Table.  To your slicer, drag Year and Month name from the Calnda table.  select January 2025 there.