Forum Discussion
Matrix with row depending one each other
Hi everyone,
I am new here and need help to implement a table like the following image. It reguards revenues current year, past year and budget.
How can it be implemented in a PBI matrix? The row structure in particular seems tricky to me.
Thank you in advance
LBoto . Use option Switch Values to row/Show values on rows in matrix visual, with Noting on row and Structure on the column
Or check calculation group Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
3 Replies
- amitchandak
Super User
LBoto . Use option Switch Values to row/Show values on rows in matrix visual, with Noting on row and Structure on the column
Or check calculation group Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
- LBotoFrequent Visitor
Thank you! so easy yet unknown
- AnonymousNot applicable
Hi,
Where exactly do I find the "Switch Values to row/Show values" option? I can't find it in the format panel.
Thanks.