Forum Discussion
Filter one column in a matrix
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
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.
8 Replies
- Greg_Deckler
Community Champion
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.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?
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.
