Quarte wise Data in Matrix 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

Q1

Q1

Q2

Q2

Q2

Q3

Q3

Q3

Q4

Q4

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

Budget

Budget

Budget

Forecast

Forecast

Forecast

Forecast

Actuals

Actuals

Actuals

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

[rsharma81]

Hi Rita,

Thanks for the reply, however, In this video an addin tool Tabular Editor is required to perform the task. Given a limitation in my office laptop I can't use Tabular Editor. Therefore, a solution is required in Power BI or if with DAX. Any help is really appreciated. 

[Ritaf1983]

With new versions, we have calculated groups "in-house".

https://www.youtube.com/watch?v=vAnb3e1NCjM

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

[rsharma81]

Hi Rita,

Thanks, It is really useful however, it seems that the Power BI installed on my system is before October and hence this option of Calculation is not available in it. Any other way we can achieve it?

Thanks for your kind help. 

[Ritaf1983 · Accepted solution]

Hi @rsharma81 

You can use disconnected table + dynamic measures, I didn't find an example with the same scenario as yours, but the method in the linked blog post has the same logic.
You need to create a table with the wanted format of hierarchies and order columns and use the selectedvalue() DAX function.

https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/?v=885...

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

[Ritaf1983]

Hi @rsharma81 
You can achieve it with calculation groups, please refer to the linked video :

https://www.youtube.com/watch?v=q-zFoQfBHXM

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