Need a option to show data as row or column

[ThejaPGamage]

I have list of materials with its age based on GRN date. My third column contain stock value. I have 2 user groups for this dash board. one group request this age as column in matrix and other request this as rows. kindly assist me to provide one power BI dashboard solution for both groups

[rohit1991 · Accepted solution]

Hi @ThejaPGamage 

Yes, this requirement can be achieved in Power BI by allowing users to toggle between viewing Age on rows or columns. The recommended approach is to use Field Parameters (Modeling >> New Parameter >> Fields) to include the Age field, then place the parameter in both the Rows and Columns area of your Matrix. A slicer on this parameter will let users choose “Row” or “Column,” and the matrix will automatically rearrange itself.

If Field Parameters are not available in your environment, you can instead build two separate matrices (one with Age on rows, another with Age on columns) and use a slicer or bookmarks to show or hide the appropriate visual. To enhance usability, rename slicer options to something user-friendly like “View by Row” or “View by Column,” apply conditional formatting to highlight the active layout, and consider using personal bookmarks so different user groups can land directly on their preferred view without adjusting the toggle each time. This way, both sets of users get the layout they want in a single, flexible report.