Forum Discussion
Hide Measure Row in Matrix
Hi AlejandroPNW ,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
If your issue is addressed,Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
Thanks Abdul,
Here's what it looks like when I add the measure with blank values:
And here's what happens when I use a visual filter to remove blank values:
As you can see, the entire 2023 dataset is removed, not just the row for the measure.
This is my visual filter:
Is this what you were suggesting?
Ignore the blank values in 2024, my data is just stale.
PowerBI's default behavior is to hide blank rows which is nice until it is not. Also, if you have a single value anywhere in the row, then PBI will display the row which may or may not be desired. This is why people have told you to mask 2023 YoY using BLANK().
If you look in the Format pane when you have the Matrix selected, you will see a Blank Rows option. Make sure it is Off. Or, try playing around with it's settings to see if you can achieve your desired results.
Howestly, the report you are building is a little strange. What is going to happen in 2025? Will you have to manually adjust all your measures? And when? Jan 1? That is just asking for trouble.
You need to work towards an agnostic solution that doesn't care what the current year is. It is not the easiest thing to do, and requires some deep DAX knowledge or maybe just asking AI.
Appreciate your response,
To some of your points:
WishAskedSooner wrote:This is why people have told you to mask 2023 YoY using BLANK().
The YoY metric does mask 2023 with BLANK(). That's why the 2023 row for YoY is blank in the screenshot.
WishAskedSooner wrote:If you look in the Format pane when you have the Matrix selected, you will see a Blank Rows option. Make sure it is Off. Or, try playing around with it's settings to see if you can achieve your desired results.
Blank rows is off, but I did try and play with that particular setting. It didn't achieve what I wanted which is one reason I reached out.
WishAskedSooner wrote:Howestly, the report you are building is a little strange. What is going to happen in 2025? Will you have to manually adjust all your measures? And when? Jan 1? That is just asking for trouble.
You need to work towards an agnostic solution that doesn't care what the current year is. It is not the easiest thing to do, and requires some deep DAX knowledge or maybe just asking AI.
What will happen when we hit January, is that this dataset and visual will show Jan and the preceding 6 months along with Jan of 2024 and those other corresponding months. The visual is a combination of SQL, DAX, and PBI filters.
You're correct that this is a tricky visual!