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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Bharathi_99
Helper IV
Helper IV

Neglect Summarized percentage values inside paranthesis in PBI

Hello All,

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 outside parentheses is what I am looking for. Any suggestions on how to display only the percentage outside paranthesis  not summarized (100%) inside paranthesis

FAST NORTH SHIPMENTS =

VAR FastMeasure = [FAST N MEASURE]
VAR NorthShipmentsTotal = [NORTH SHIPMENTS TOTAL MEASURE]

RETURN
    DIVIDE(FastMeasure, NorthShipmentsTotal, 0)

This is my Measure

1 ACCEPTED SOLUTION
v-zhouwen-msft
Community Support
Community Support

Hi @Bharathi_99 ,

Regarding your question, Changes cannot be made directly from the visualization settings. You can additionally create a tooltip page.

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

vzhouwenmsft_2-1716367201268.png

Please follow these steps:

1.Create a new report page and register it as a tooltip page

vzhouwenmsft_1-1716366732039.png

2.Putting your measure into card visualization object

vzhouwenmsft_3-1716367896154.png

3.Final output

vzhouwenmsft_4-1716367931569.png

 

 

 

 

View solution in original post

1 REPLY 1
v-zhouwen-msft
Community Support
Community Support

Hi @Bharathi_99 ,

Regarding your question, Changes cannot be made directly from the visualization settings. You can additionally create a tooltip page.

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

vzhouwenmsft_2-1716367201268.png

Please follow these steps:

1.Create a new report page and register it as a tooltip page

vzhouwenmsft_1-1716366732039.png

2.Putting your measure into card visualization object

vzhouwenmsft_3-1716367896154.png

3.Final output

vzhouwenmsft_4-1716367931569.png

 

 

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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