Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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.
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
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.
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.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
63 | |
52 | |
47 |
User | Count |
---|---|
218 | |
86 | |
64 | |
63 | |
60 |