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.
Hi AlejandroPNW ,
To remove 2023 from your Power BI matrix using a date filter:
- Add the Date field to the Visual level filters pane.
- Click the dropdown on the Date field, select Advanced filtering.
- Set the filter condition to is not and choose
2023as the value to exclude it.
This will remove 2023 from your matrix visual.
If I remove all of 2023, I would lose the values and the measure, no? I wanted to remove only the row with the blank line which occurs in 2023 in addition to the sales values.
Hi AlejandroPNW ,
In the matrix, apply a filter on the measure to exclude blank values:
Drag your measure to the Visual-Level Filters pane.
Set the filter condition to is not blank. This will ensure only rows with valid data are displayed, including the values for 2023, while hiding the unwanted blank line.
Did I answer your question? 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.
