Forum Discussion

rainbow_isla's avatar
rainbow_isla
Frequent Visitor
5 years ago
Solved

Matrix table values with %

I am having trouble to show total response in matrix table. By usign row %, I showed % in the table, but how can I show total response by people (not by %). This is the example table what I want. ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, rainbow_isla 

    Thank you very much for your message.

    In my opinion, there are two ways to achieve this.

     

    1.

    Under the each column there are two measures needed. One is for the Count, and the other is for the Percentage. In this scenario, insert two times of the same column, that is the ID column, into the Value section, then each cleanliness-column would have two results. Manually hide one of those.

     

    2. If you have Tabular Editor as an external tool in Power BI, then you can create two different measures for 5 columns (including Total). I am not sure if you have installed Tabulare Editor in your Power BI desktop, but please let me know then I can show you how to proceed.

     

    The link is down below.

    Thank you.

     

     

    https://www.dropbox.com/s/z0jc10ef4kloegc/toy.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi rainbow_isla ,

     

    I agree with the method provided by Jihwan_Kim . As the following operation: Drag the columns that do not need to be displayed to the smallest:

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, rainbow_isla 

if it is OK with you, please share your sample pbix file, then I can try to have a look to come up with a more accurate solution.

Thank you.

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

rainbow_isla's avatar
rainbow_isla
Frequent Visitor
5 years ago

Hi Jihwan_Kim 

Thanks for your reply. Here is the link for the sample pbix file.

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, rainbow_isla 

    Thank you very much for your message.

    In my opinion, there are two ways to achieve this.

     

    1.

    Under the each column there are two measures needed. One is for the Count, and the other is for the Percentage. In this scenario, insert two times of the same column, that is the ID column, into the Value section, then each cleanliness-column would have two results. Manually hide one of those.

     

    2. If you have Tabular Editor as an external tool in Power BI, then you can create two different measures for 5 columns (including Total). I am not sure if you have installed Tabulare Editor in your Power BI desktop, but please let me know then I can show you how to proceed.

     

    The link is down below.

    Thank you.

     

     

    https://www.dropbox.com/s/z0jc10ef4kloegc/toy.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

    • rainbow_isla's avatar
      rainbow_isla
      Frequent Visitor
      5 years ago

      Thanks Jihwan_Kim How did you manually hide columns?

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi,

        Thank you for your feedback. 

        You can control the width of each column by dragging your mouse, and you can drag it until you don't see the column. (Somthing like making the width of column to 0.0000000001cm)

        Thank you.