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 💡
Hi StevenT
You can let users pick dimensions with a field parameter. If they choose Product Category, you add a simple DAX rule so Segment shows up under it. If they pick Country, that rule hides Segment the matrix then adapts naturally to their choice.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
I use a field parameter for the primary level (first row). How would I build it so that if a user picks one from the main parameter, a secondary row appears or hides if there is no secondary needed?
Here's my field parameter
what I would want is something like if the pick artist, the secondary row appears which would be TrackList([Title]), but if they pick any other, it dissapears or is hidden in the matrix..