So, currently, I'm in the process of convering tableau reports to power BI. I have attached two screesnhots. In the first screenshot, there are multiple rows with multiple columns and subcolumns and in terms of the values for each row/column/subcolumn.. two measures are displayed one is in M, other is in %. I have hid the data for privacy purposes. Please tell me how I can do this. I haven't been able to use subcolumns in BI before. The 2nd screenshot is basically a simpler one that has all zeroes but the concept is the same. I want to display the data in that style. Please let me know how to do it.
Hi @Anonymous
It seems basic hierarchical matrix.
more information about matrixes :
https://www.youtube.com/watch?v=hyKdOjI1_zk
PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
