Forum Discussion

Myself_Learning's avatar
Myself_Learning
New Member
3 years ago

Three header in Power BI report

Hi All,

 

I have a simple, yet not able to find a solution query. I am creating a simple table report on all my column in a table.

It just that i need to add 2 header on top of some column according data, as in sample below.

So, "Provision" is not in table, "Years Begning", "Month Begning" & "Month End" is not in table, which i need to be added dynamically. This table has 43 columns and i need to divide this report into 3 part and this is the middle part.

 

The mergning got change while posting the question, however "years begning" should have 2 columns under it and the other 2 also should have 2 columns under them likewise.

 

Provision
Years BegningMonth BegningMonth End
NUMOFYEARSTARTSUMASSUREDOFYEARSTARTNUMOFMONTHSTARTSUMASSUREDOFMONTHSTARTNUMOFMONTHENDSUMASSUREDOFMONTHEND
10055000994500010055000
200650002006500020065000
300570003005700028055000
400580003505600040058000
500590005005900040050000
600600006006000060060000
700610006506000070061000
800620008006200070058000
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Myself_Learning ,

     

    According to your statement, I think matrix visual should meet your goal. You sample look like a matrix with hierarchy level.

    For reference: Create a matrix visual in Power BI - Power BI | Microsoft Learn

    For more help, I need to know your data model. You can share a sample file with me and show me a screenshot with the result you want.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.