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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Enhanced detail labelling on a bar chart not adhering to formatting set by the measure

I am keen to start using the new label detail feature on the chart formatting, but one thing I noticed is that the detail label is not adhering to the  formatting set in the measure.  In this example, I have the main value as a currency, and then a % change measure underneath with some condition formatting.  The % change should be shown as a percent.  The format for that measure is set to %, I've set "Auto" to "None", but it only shows as a number, not as a percentage.  When I Select "Custom" from under display units, I am unable to select the % measure from the list, or do anything else with that.  I would rather not have to set up additional measures specifically to pass an explicit formatting to the measure in order for this to display correctly, the detail should adhere to the measure's formatting set on the measure that is being used.  

 

Here's what I see - NOTE - this is randomized data that I am using for this example:  

 

NicEdmonds_0-1707304449781.png

 

Status: Investigating

Hi @Anonymous ,

 

As you mentioned above:“The % change should be shown as a percent.”

You may try set the measure format in measure tools like

vxiaoyanmsft_0-1707371336520.png

or  try to format it in this way and check it.

FORMAT( [%Change Revenue LW Testing],"Percent" )

 

I did a simple test and it works in my side.

 

 Best regards.
Community Support Team_Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @Anonymous ,

 

As you mentioned above:“The % change should be shown as a percent.”

You may try set the measure format in measure tools like

vxiaoyanmsft_0-1707371336520.png

or  try to format it in this way and check it.

FORMAT( [%Change Revenue LW Testing],"Percent" )

 

I did a simple test and it works in my side.

 

 Best regards.
Community Support Team_Caitlyn

jcaprot20
Regular Visitor

This helped me using the 

FORMAT( [%Change Revenue LW Testing],"Percent" )