Forum Discussion

Ayupchap's avatar
Ayupchap
Helper III
9 years ago
Solved

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 ...
Need Help
Show and Tell
Tutorial Requests
  • vesztamas's avatar
    vesztamas
    9 years ago

    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

Ayupchap's avatar
Ayupchap
Helper III
9 years ago

WOOHOOO!!! Amazing thanks so much!!!

vesztamas's avatar
vesztamas
Frequent Visitor
9 years ago

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's avatar
    jdt008
    Advocate II
    9 years ago

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

    • vesztamas's avatar
      vesztamas
      Frequent Visitor
      9 years ago

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

       

      • jdt008's avatar
        jdt008
        Advocate II
        9 years ago

        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?