Forum Discussion

MaxShema's avatar
MaxShema
Regular Visitor
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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.