Quarterly Trend in Matrix in Power BI

[rsharma81]

Hi,

I am trying to create a table in matrix which will show the quarterwise Budget, Forecast and Actuals. The below is the output I am getting while putting the data in the matrix in Power BI.

Q1

Q2

Q3

Q4

Budget

Forecast

Actual

Budget

Forecast

Actual

Budget

Forecast

Actual

Budget

Forecast

Actual

A

B

However, I want this is to be show in other way where Budget will show with all the quarters, then Forecast and so on. for Example.

Budget

Forecast

Actuals

Q1

Q2

Q3

Q4

Q1

Q2

Q3

Q4

Q1

Q2

Q3

Q4

A

B

Any help in this regards is highly appreciated.

Thanks,

Rakesh

[Ritaf1983 · Accepted solution]

Hi @rsharma81 
Take a look at my response to your second post about this issue :
https://community.fabric.microsoft.com/t5/Desktop/Quarte-wise-Data-in-Matrix-Power-BI/m-p/3809358#M1...

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