Showing percentage and number values in visuals at the same time

[istik]

Hello

I'm trying to showing percentages and number at the same time in my visual,

ex:  88.15% (100 000)

or: 100 000 ( 88.15%)

but I tried many different visuals and I did not make it.

Do you have any ideas?

[Tejasvi_munge]

Hi,

There is no perfect solution for this. However, few workarounds which you can try using Grid/Matrix visual-

1. Concatenate two columns containing values and percentage.

2. Merge two columns in query editor using required delimiter.

3. Pull the required columns in the grid and do the formatting such that it looks like they belong to same column, for instance column shown in below image -

Regards,

Tejasvi

[Anonymous]

Hi,

This would be very interesting, is there any new functionnality to achieve that ?

Best regards,

Benjamin

[Anonymous]

Hi,

This would be very interesting, is there any new functionnality to achieve that ?

Best regards,

Benjamin

[adanyoshimoto]

Hi, I think i have the same problem, did you get the solution for this problem?

[jhwon]

you solved it? I tried using solutions here, but nothing worked perfectly....

[v-yuezhe-msft · Accepted solution]

Hi @istik,

According to the sample data in your screenshot and based on my test, we will need to create a calculated column in the original table and make the values in the calculated column display as 100 000 ( 88.15%) or 88.15% (100 000) format. Please note that after creating the calculated column, we can only drag it into Table visual in order to show the values properly(as shown in the following screenshot). As the calculated column is text type, in other visuals, it will be counted.



For more details about how to create a calculated column in your scenario, you can check the example in the attached PBIX file.
 

Thanks,
Lydia Zhang

[Habib]

Power BI provides a better solution to calcuate % automatically and you can show these in your tooltips quickly

Please refer to below. I have placed a staked chart and put Sales mearure in Value as well as in Tooltip. Now its showing sales two time in tooltips.

Next do a right click in Tooltip section on Sales and go to Quick Calc Option.

Now change the Show Valu as to Percentage as below

It will conver the tooltip to show as % of GT.

Hope this will resolve your problem.

[Nhallquist]

My initial thought is do to something with the Tooltip.  I'm assuming that the goal of the graph is to find the exception, a category that is, maybe, under 90%.  If you use the Tooltip, you can allow users to browse the graph with less clutter, then hover over and get the context of the additional info.  something like the image below.

You can accomplish this by adding a measure, as seen below.

Nate

[istik]

thanks for the reply, yes I can add a tootips, but I want to know if there any way to show the % and values at the same time

like 90%(1 000 000)