Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
I'm trying to create a matrix but with a slight modification.
Usually, Power BI allows us to use Measures as Values and Months as Columns.
What I'm looking for is to switch the two (1 and 2 in the image below).
I'd lke to use Measures as Columns and Months as Values.
For example:
The above matrix should look like:
Measure Goal Actual
Sector | Program | Jan 2018 | Feb 2018 | Mar 2018 | Jan 2018 | Feb 2018 | Mar 2018
#value #value #value #value #value #value
#value #value #value #value #value #value
Is this currently possible? Or is there a workaround?
Thanks!
Solved! Go to Solution.
Hi again
Take a look at this video :
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
final result:
you can download at this link: Sample_2
You need to create the calcualtion group in Tabular Editor !!
Best regards
Bruno Costa | Continued Contributor
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍
Take a look at the blog: PBI Portugal
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Hi again
Take a look at this video :
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
final result:
you can download at this link: Sample_2
You need to create the calcualtion group in Tabular Editor !!
Best regards
Bruno Costa | Continued Contributor
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍
Take a look at the blog: PBI Portugal
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Hi,
This is the exact format I would like to produce for my matrix visual. Are you able to share the pbix again? I tried clicking on the link but it has probably expired/removed. Would really appreciate it. Thank you.
Hi @onurbmiguel_
Thank you for providing the sample file! It will certainly help me understand how to figure this out.
You're a saviour!
Hi Rishabh-Maini
You can do that with calculation groups, you will need two calculatio itens "Goal" and other "Actual"
Also you can try the Fields parameters (it accepted measures as parameter)
Share one pbix with some dummy values and i will try to help you.
Best regards
Bruno Costa | Continued Contributor
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍
Take a look at the blog: PBI Portugal
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Hi @onurbmiguel_ ,
Thank you for your reply.
I have never used calculation groups before, I'll be really thankful if you could provide some insights!
I've attached a file with some dummy values, let me know if that helps.
User | Count |
---|---|
129 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
63 | |
54 |