Display number and percentage at same time in a table

[Anonymous]

Hi everone

I have a two KPIs

this is their table

KPI                              Actual         Planned

Revenue %                    20%                30%

Saving Value                2454                3000

I want to use a table and have the values in both Percentage and Numbers but its not working i can only choose one !

can you help me please ?

[v-lili6-msft · Accepted solution]

hi, @Anonymous

After my test, you could do these as below:

Add two calculate measure for each column

New Actual = IF(SEARCH("%",SELECTEDVALUE('Table1'[KPI]),1,0)>0,FORMAT(CALCULATE(SUM('Table1'[Actual])),"0%"),CALCULATE(SUM('Table1'[Actual])))

New Planned = IF(SEARCH("%",SELECTEDVALUE('Table1'[KPI]),1,0)>0,FORMAT(CALCULATE(SUM('Table1'[Planned])),"0%"),CALCULATE(SUM('Table1'[Planned])))

Result:

here is pbix, please try it.

https://www.dropbox.com/s/qvw2ulfxfic7fdb/Display%20number%20and%20percentage%20at%20same%20time%20in%20a%20table.pbix?dl=0

Best Regards,

Lin

[Anonymous]

This is Perfect,

Thanks alot Lin it worked like magic.

Hope you have a great day 🙂

Regards,

Abdulkareem