Forum Discussion
Matrix - Hide/Show secondary Rows in matrix
Hi, is there a way to dynamically hide/show a secondary dimension in a matrix, depending on what a user chooses in a field parameter?
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 💡
9 Replies
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.
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 parameterEntitySelectory = {("Title", NAMEOF('TrackList'[Title]), 0),("Genre", NAMEOF('Genre'[Genre]), 1),("Artist", NAMEOF('Artist'[Artist]), 2),("Album", NAMEOF('Album'[Album]), 3),("Record Label", NAMEOF('RecordLabel'[RecordLabel]), 4),("Region", NAMEOF('Region'[Region]), 5),("Retail Sales - Tracks", NAMEOF('PurchasedFrom'[PurchasedFrom]), 6),("Retail Sales - Albums", NAMEOF('PurchasedFrom'[Purchased From]), 7)}
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 parameterCategory = {("Title", NAMEOF('TrackList'[Title]), 0),("Genre", NAMEOF('Genre'[Genre]), 1),("Artist", NAMEOF('Artist'[Artist]), 2),("Album", NAMEOF('Album'[Album]), 3),("Record Label", NAMEOF('RecordLabel'[RecordLabel]), 4),("Region", NAMEOF('Region'[Region]), 5),("Retail Sales - Tracks", NAMEOF('PurchasedFrom'[PurchasedFrom]), 6),("Retail Sales - Albums", NAMEOF('PurchasedFrom'[Purchased From]), 7)}
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..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,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to danextian, DavidHenry DataVitalizer and lbendlin for prompt and helpful responses.
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna KumarHi StevenT,
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar
