cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Ayupchap Member
Member

Making totals in a Matrix Visual Percentages?

Hi there

 

Still totally new at all of this.  Struggling to show a matrix visual as a %.  Is there anyway to do this?  if so easy to follow steps would be so great as I'm seriously using the trial and error method of building out these things and not sure the kind of power this app has and whats possible.  Any help much appreciated.  Below is a screenshot of the matrix window so far.

 

matrix.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
vesztamas Frequent Visitor
Frequent Visitor

Re: Making totals in a Matrix Visual Percentages?

Hello,

 

on Visualiztaion panel at Values section you drop down at the requires value. After it select Quick calc and show value as Percent of Grand total.

 

Br, Tamas

View solution in original post

7 REPLIES 7
vesztamas Frequent Visitor
Frequent Visitor

Re: Making totals in a Matrix Visual Percentages?

Hello,

 

on Visualiztaion panel at Values section you drop down at the requires value. After it select Quick calc and show value as Percent of Grand total.

 

Br, Tamas

View solution in original post

Ayupchap Member
Member

Re: Making totals in a Matrix Visual Percentages?

WOOHOOO!!! Amazing thanks so much!!!

vesztamas Frequent Visitor
Frequent Visitor

Re: Making totals in a Matrix Visual Percentages?

You are welcome, but say thank you for power bi developers. This easy way of showing the percentage is able from February version of Power BI desktop.

jdt008 Regular Visitor
Regular Visitor

Re: Making totals in a Matrix Visual Percentages?

Do the new quick calc functions work with a tabular model? I cannot find them.  Thanks.

vesztamas Frequent Visitor
Frequent Visitor

Re: Making totals in a Matrix Visual Percentages?

I just made a qucik test with MS tabular example, and yes it's working.

 

quick_calc.jpgquick_calc2.jpg

jdt008 Regular Visitor
Regular Visitor

Re: Making totals in a Matrix Visual Percentages?

Thanks for the quick response.  Please see what I am seeing below.  I've also pasted a screenshot to show you what version of Power BI I am on.  To clarify, I am connecting to a tabular model through SSAS.  Any thoughts or suggestions as to why I'm not seeing the new quick calc in the drop down?

 

2017-02-13.jpg2017-02-13_2.jpg

vesztamas Frequent Visitor
Frequent Visitor

Re: Making totals in a Matrix Visual Percentages?

Unfortunately, I don't know. please share the pbix, and I try to figure out. thank you Tamas

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors