Forum Discussion
Nested column layout in a Power BI Matrix visual
- 1 year ago
Hi heranaval
Since in Power BI, the matrix is structured and does not allow for individual cell customization or merging options, the closest representation to what you provided in the image would be a tabular layout, with the category placed at the beginning, as shown in the image.The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
- 1 year ago
Hi heranaval
While the layout is fairly simple without the extra Type column, adding it complicates things. You'll need a disconnected table that includes all the necessary column and row combinations. Additionally, you should have a column for the dynamic format string (please search how to set this up) since those values will be formatted differently. Lastly, you'll need a measure that returns the correct values based on the row/column combinations. Also, it not possible to merge headers vertically such as the one above code and after Feb. This is the closest I could get to - any more than this and you're looking into a premium custom viz like the matrix from inforiver .
Please refer to the attached pbix.
- Anonymous1 year ago
Hi heranaval ,
Pls has your problem been solved? If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.
If not, please provide a more detailed description, preferably some more virtual sample data, and the expected results.
Best Regards,
Stephen Tao
Hi heranaval
Since in Power BI, the matrix is structured and does not allow for individual cell customization or merging options, the closest representation to what you provided in the image would be a tabular layout, with the category placed at the beginning, as shown in the image.
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thank you for your help!