Forum Discussion
How to show additional data before main in matrix?
Hello
I have some data that describe the changes in certain indicators over a period of time. To illustrate their changes, I need to build a Matrix. This is all simple and clear.
But also, for each indicator, I have additional measures that I need to place in front of the main columns of the Matrix. Ideally, it should look something like this:
Data source looks like this:
Off course, I can calculate the value of these measures and add to matrix as a card vizualisation. But I need exactly to add this as additional columns before the years columns.
Would be grateful for any help and ideas!
1 Reply
- AnonymousNot applicable
Hi MaxShema ,
You can't to achieve this format in Power BI with Matrix.Your desired result means that your matrix has two Row headers, which are automatically converted to a hierarchical structure in Power BI, and you can only achieve what is shown below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.