Forum Discussion
Hide Rows in Matrix Visual based on Blank Values in Date Range
I have a matrix visual with dates across the top as column headers, then values that appear in cells with background colors if values exist on that date. Every row in the matrix has at least one value for a date, but for a given date range, some rows will not have any values displayed (they are out of the selected range, but present). To save space, I would prefer to hide the rows that have no values for the selected, visible date range (using a time slicer to select dates). Is there a way to conditionally hide rows based on the current start/end dates picked from the slicer. If Value field for the visible date range is blank, then hide that row, else display it.
3 Replies
- AnonymousNot applicable
This is a new feature in the May release but is in Preview
Power BI May 2024 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI- msr15105kFrequent Visitor
Which feature are you referering to? Thanks.
- AnonymousNot applicable
Sorry, looks like this new feature is to add blank rows, not remove them. It looks like the Power BI development is trying to get the Matrix visual to act like Excel, so i is possible they will add this.
If you google this, the eamples are to remove the blank rows in PowerQuery