Forum Discussion
Matrix - Hide/Show secondary Rows in matrix
Things are getting clearer now, you can’t make a field parameter itself add/remove extra levels, but you can simulate it., create a conditional field (measure) that only returns TrackList[Title] when the selected parameter = “Artist,” and returns BLANK() otherwise, then add that measure as the second row in your matrix. Power BI automatically hides a matrix level if it only contains blanks, so the secondary row will appear only when “Artist” is chosen.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
Not sure what you mean by secondary row, but you can hide hierarchy elements by collapsing them and not showing the +/- icons.
Consider instead allowing "Personalize Visuals" and teaching your report users how to operate that.
I use a field parameter for the primary level (first row). Works great. But I would only want a secondary row under the selected one here, where if the user chooses for example,
("Artist", NAMEOF('Artist'[Artist]), 2),
a secondary dimension is visible and it would be
("Title", NAMEOF('TrackList'[Title]), 0),
So it would look like this if artist is selected, but if Region selected, then there wouldn't be a secondary dimension.
Simply put, I wouldn't even a blank row to appear below the Entityselector field
Here's my field parameter