cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

measures on rows matrix

Hi, 

 

Is it possible to have measures on rows in a matrix? 

I know there is an option in format-values and turn on "show on rows"

But what I further want to achieve is for example:
            this month    last year   TYD TYD-1
sales
cost
result

 

Sales Cost and results are all measures..

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: measures on rows matrix

Hi @Coan7 ,

 

I was assuming that those were columns on your data, can you please a sample share, as @amitchandak  you need to make a use between switch function and an auxiliary table.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

6 REPLIES 6
Highlighted
Super User IV
Super User IV

Re: measures on rows matrix

There is property "show on row".  that can help.

 

But what you are writing splitting meaures into both row and column



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper IV
Helper IV

Re: measures on rows matrix

Yes, splitting measures into both row and column.

 

Possible workaround would be creating a table with measures names and then using switch.

I was hoping there is another quick way.

Highlighted
Super User III
Super User III

Re: measures on rows matrix

Hi @Coan7 ,

 

On the Matrix option find the option SHOW ON ROWS if you activate that, the measure will be shown as you need.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper IV
Helper IV

Re: measures on rows matrix

Tnx, I only get one column with the measures.

 

I need  columns for example: last year, TYD and TYD-1

Highlighted
Super User III
Super User III

Re: measures on rows matrix

Hi @Coan7 ,

 

I was assuming that those were columns on your data, can you please a sample share, as @amitchandak  you need to make a use between switch function and an auxiliary table.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

Highlighted
Super User IV
Super User IV

Re: measures on rows matrix

One option is union and summarize

 

union ( summarize( table[group_by1],table[group_by1],"measure","Sales","MTD",<MTD formula>, "YTD",<Ytd Formul>...),

summarize( table[group_by1],table[group_by1],"measure","Cost","MTD",<MTD formula>, "YTD",<Ytd Formul>...)

...

 

)

Group, add constant value for measure name and MTD, QTD, YTD, last year etc.

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors