Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ChrisMarini
Frequent Visitor

Format percentages in tooltips

I have a number of visualizations across several dashboards that show percentages based on a count of an ID variable (in this case, JPOID). the visual below uses a count of JPOID, then using the "show as % of grand total" option. I want the percentage to read round to the nearest whole number in the tooltip.

ChrisMarini_0-1643294295766.png

I tried creating a new column in the dataset that I could then format as I saw fit, but it had an unintended consequence that makes it unacceptable.The image on the left shows the dashboard with the created column being used with a certain county selected, and the one on the right uses the show as percent option. Using my calculated column, when I make a selection in one visualization, the other ones that show percentages highlight that selection as a percentage of the whole, not highlighting the values of that selection.

ChrisMarini_1-1643294872299.pngChrisMarini_2-1643294878091.png

Is there a way to round percentages in a tooltip without this lose of readability/interactivity?

 

This is the code I used to generate my calculated column (JPOind is a column I made that just has a value of 1 for each observation to make counting/aggregating more straightforward, and JPOcount is then a column that counts the value of JPOind)
JPOpercent = 'PowerBI Data'[JPOind]/'PowerBI Data'[JPOcount]
1 REPLY 1
lbendlin
Super User
Super User

You should use measures, not calculated columns.

 

Also consider the option of creating dedicated tooltip pages where you can control the formatting better.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.