Percentage of grand total in parentheses

[busybee]

I have a 100% clustered column chart. In the Values section, I have a column set to '% of grand total'. When I hover over my chart, it shows 2 percentages, one outside parenthesis and the other in parentheses. The percentage in parentheses is what I am looking for. Any suggestions on how to display only the percentage in parentheses?

[Anonymous]

Hi @busybee ,

Do you wanna get a result as shown in below pic?

If so ,you can create a calculated column as below:

Column = DIVIDE('Table'[Visitor],SUMX(ALL('Table'),'Table'[Visitor]))

Or a measure as below:

Measure 2 = DIVIDE(SUMX(FILTER('Table','Table'[City]=MAX('Table'[City])),'Table'[Visitor]),SUMX(ALL('Table'),'Table'[Visitor]))

For details,pls click here to check my sample .pbix file.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[busybee]

The percentage in the parentheses seems to be correct. How do I only display the percentage in parentheses(28.33 %) and not 6.62 %?

[Anonymous · Accepted solution]

Hi  @busybee ,

So you wanna get a result as beow?

Create a calculated column as below:

Column = DIVIDE('Table'[Visitor],SUMX(FILTER('Table','Table'[Date]=EARLIER('Table'[Date])),'Table'[Visitor]))

Here is the .pbix file.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Bharathi_99]

If I don't want to show values in paranthesis, how to do that
In my PBI, it's showing as 92.8% (100 %)
I don't wnat to show (100%)

[busybee]

The formula mentioned above does not work with a combination of positive and negative values. I have attached a Sample Power BI dashboard. 

https://drive.google.com/file/d/1CZh5WPWqz5BK0txFkC8HabsjAAfs58xT/view?usp=sharing 

In this dashboard, Col1 is the axis, Col2 is the legend and Col3 contains the values. Any suggestions on how to resolve this with a combination of positive and negative values? 

[busybee]

I have a combination of negative and positive values in the column corresponding to the Visitors column in my Power BI  file. The percentage displays correctly on one of the bars but incorrectly on the other bar. Could this be because I have a combination of negative and positive values in the column corresponding to the Visitors column in my Power BI  file? 

[busybee]

I just created a Temp Table filtered with only the positive values of the field utilized as value. I created a similar chart and the percentages match. 

[parry2k]

@busybee you can create our custom tooltip, read this post

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡