How to fix percentage to numbers for reference line

[Frixel]

Hello,

How to fix this that i don`t see the % but in numbers in the reference line?

I can`t find it.

[bhanu_gautam]

@Frixel < Currently it is nor possible in 100% stacked bar chart but i have found one old solution and you can also use Stacked column chart

At present, this is not possible in Power BI. Though, you can use one of the custom visuals to achieve this. This still has some minor limitations like Legend colours can be switched but not directly in Desktop. Unlike the ability to switch colours with the stock stacked charts.

 
Download link for the custom visual in this page
https://pbivizedit.com/gallery/column_100stack_label_value 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

•  anyone, irrespective of technical skills, can create their own visuals
• 15 minutes to create a visual from scratch
• opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problem/errors.

You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

@asitm 

[Anonymous]

Hi, @Frixel 

Thanks for @Swapnilmandloi and @amitchandak reply. What is the visual object you are using and you can give non-sensitive data that reproduces the problem at hand for testing.

Best Regards,
Yang
Community Support Team

[Frixel]

I used the 100% stacked colomn chart

The number 283 is the counting.

[Frixel · Accepted solution]

Whaa, is see it now. I used the wrong vizual.

I must use the normal stacked colomn chart 😃

thanks all for you helps 😍

[JoaoMarcelino]

😄
Choosing the right visual more than a science, is an art 😉
Cheers,
Joao

[Frixel]

Adjust Data Labels:

• In the Analytics pane, under the reference line settings, find the Data label section.
• Adjust the Display units to show numbers instead of percentages. You can set it to None to display the exact number.
  
  I don`t have that option to show numbers 😅

[Swapnilmandloi]

If you don't see the option to adjust the display units to show numbers instead of percentages in the Analytics pane, it's likely that the visual or reference line settings do not support this feature directly. However, you can work around this issue by following these steps:

Workaround Steps:

1. Check Data Formatting:

   • Ensure that the data source itself provides numbers instead of percentages. If the data is in percentage format, you may need to adjust it in Power Query or directly in your data source.

2. Create a New Measure:

   • If the reference line value is calculated from a measure that returns a percentage, create a new measure that converts it to a numeric value.
   • Example DAX formula to convert percentage to a number:
     DAX

     NumericMeasure = [PercentageMeasure] * 100

3. Add Reference Line with Numeric Value:

   • Use the new measure (NumericMeasure) as the value for your reference line.
   • This way, the reference line will display the numeric value instead of a percentage.

Example:

1. Create New Measure:

   • Go to Modeling -> New measure.
   • Enter the DAX formula:
     DAX

     NumericMeasure = [PercentageMeasure] * 100

2. Add Reference Line:

   • Select your visual and go to the Analytics pane.
   • Click on the reference line you want to add (e.g., Constant line).
   • Set the Value to NumericMeasure.

3. Adjust Data Labels:

   • If the Display units option is not available, ensure the data label settings are configured to show the exact value.
   • In the Format pane, you may find more detailed settings for data labels.

Verify Visual Properties:

1. Format Pane:

   • Sometimes the formatting options are under the Format pane instead of the Analytics pane.
   • Select the visual, go to the Format pane, and look for settings related to data labels or reference lines.

2. Custom Visuals:

   • If the built-in visuals don't meet your needs, consider using custom visuals from the Power BI Marketplace that offer more flexibility in formatting.

Detailed Steps to Find Data Label Settings:

1. Select the Visual:

   • Click on the visual where you need to adjust the reference line.

2. Open the Format Pane:

   • Look for the Data label section under the Format pane.
   • Adjust settings to ensure the labels display the values as numbers.

[Frixel]

Where can i find the Analytics pane?

[Swapnilmandloi]

Open the Analytics Pane:

• After selecting your visual, you will see three icons on the right side of the pane: Fields, Format, and Analytics.
• Click on the Analytics icon (the third icon that looks like a magnifying glass with a chart).
  

[Swapnilmandloi]

To change the reference line from displaying percentages to displaying numbers in Power BI, you'll need to adjust the data formatting and the properties of the reference line in your visual. Here's how to do it:

Steps to Change Percentage to Numbers in Reference Line

1. Select Your Visual: Click on the visual where you want to change the reference line formatting.

2. Add or Edit Reference Line:

   • Go to the Analytics pane.
   • Select the reference line (constant line, max line, min line, etc.) that you want to modify or add a new one.

3. Format the Reference Line:

   • In the reference line settings, look for the Value field where you specify the value of the reference line.
   • Ensure that the value you enter is a number. If the data being referenced is in percentage format, you might need to adjust the calculation or the measure used to ensure it's a numeric value.

4. Adjust Data Labels:

   • In the Analytics pane, under the reference line settings, find the Data label section.
   • Adjust the Display units to show numbers instead of percentages. You can set it to None to display the exact number.
   • You can also adjust the Text size, Color, and other formatting options here.

Example for a Line Chart

1. Select Line Chart: Click on your line chart visual.
2. Analytics Pane: Open the Analytics pane.
3. Add Constant Line: Click on Add under the Constant line section.
4. Set Value: Enter the numeric value you want for the constant line (e.g., 50 instead of 50%).
5. Format Data Label:
   • Set Display units to None.
   • Adjust other settings such as Text size and Color as needed.

Adjusting Measure Calculation

If your measure itself is calculated as a percentage, you may need to create a new measure that converts this to a number. For example, if your measure PercentValue is a percentage, you can create a new measure:

DAX

NumberValue = [PercentValue] * 100

Then use NumberValue for your reference line.

Detailed Example:

1. Create a New Measure:

   DAX

   NumberValue = [PercentValue] * 100

   Replace PercentValue with the actual measure or column you are using.

2. Use the New Measure: In your reference line, use NumberValue as the value.

3. Format the Reference Line:

   • Go to the Analytics pane.
   • Select the reference line and ensure it uses NumberValue.
   • Adjust the Data label to display numbers correctly.

[amitchandak]

@Frixel , Not sure of the visual you are using. But change the format to none and try