Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Rishabh-Maini
Helper II
Helper II

Use Measures and Months in Matrix as Columns

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:

RishabhMaini_0-1668789119624.png


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!

1 ACCEPTED SOLUTION
onurbmiguel_
Power Participant
Power Participant

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: 

onurbmiguel__1-1669029383882.png

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 

 

wp-1586527108426

 


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 


 


View solution in original post

5 REPLIES 5
onurbmiguel_
Power Participant
Power Participant

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: 

onurbmiguel__1-1669029383882.png

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 

 

wp-1586527108426

 


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 


 


Anonymous
Not applicable

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!

onurbmiguel_
Power Participant
Power Participant

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 

 

wp-1586527108426

 

 


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. 



Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.