cancel
Showing results for
Did you mean:
Frequent Visitor

Display number and percentage at same time in a table

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

Re: Display number and percentage at same time in a table

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%20i...

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team

Re: Display number and percentage at same time in a table

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%20i...

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

Re: Display number and percentage at same time in a table

This is Perfect,

Thanks alot Lin it worked like magic.

Hope you have a great day

Regards,

Abdulkareem

Announcements

Community Highlights

Find out what's new in the Power BI Community!

Power Platform Summit North America

Register by September 5 to save \$200

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 188 members 1,996 guests
Recent signins: