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 💡
Yes — you can manage this using field parameters in Power BI. Create a field parameter for your secondary dimension, then use a slicer to let users pick which one to show. The matrix will automatically update based on that selection.