How to format a specific value of a column in % ?

[Gavroche97]

Hi,

I would like to have a matrix visual showing the repartition of a numeric variable depending on 2 category variable. 

I wish to have a rows that would give the proportion in percent.

I have prepared my table by pivoting the columns I wish to use, unfortunately I can't figure out how to set up the percent row in %...

I only know how to format and entire column, but my column contains all values including values that I do not wish to have as %.

Can anyone help ? Thanks !

Best regards,

Victor  

[mangaus1111 · Accepted solution]

Hi @Gavroche97 ,

see my pbi file

https://1drv.ms/u/s!Aj45jbu0mDVJi052Gl_UviY1W6Yf?e=QQywMw

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

[mangaus1111]

Hi @Gavroche97 ,

it would be great if you can share some sample data of your table and your expected result

[Gavroche97]

Exemple data would be:

Cat1 Cat2 Value

A       Red     12

A       Blue    24

A       %       0,5

B       Red     3       

B       Blue     4

B       %         0,75

C       Red      7

C       Blue     21

C       %         0,3333

Would like to put that data in a Matrix visual such as

             A             B             C

Red       12            3             7          

Blue      24            4             21         

%         50%          75%     33,33%                 

I found a way when generating the % value to "format" it in percent but it results in a string column, so I cannot transform the data anymore after that...