Need help turning gauge visual into a percentage

[RingoSun]

I have this gauge visual which contains Actual sales and target sales

But instead of displaying whole numbers in the visual, I want to display percentages instead. I tried just simply using the "Percent of grand total" option but it shows me 100% which is obviously wrong.

What can I do here?

SAMPLE PBIX

[AppleSeedy]

I was just dealing with this. Click on the data field in the data column - NOT the checkbox (which should be ticked for the data you are displaying), click the actual data label in the data column. The ribbon at the dop should change to "Column Tools" -

Navigate to "Format" and change the dropdown to "percentage" - 

[Seanan]

Hi @RingoSun 

I've managed to get the result you are looking for.

However, to get the value as a percent I've had to create a Max measure to divide the sum of sales by (This is hardcoded in this example). 
Does your dataset contain a maximum value column or any data at all or would the max be 2x of the value? Which is currently what your 1st post picture shows.

Please find the updated PBIX here.

[bcdobbs]

Hi,

Are you trying to calculate a percentage of sales against target?

If so I defined 3 measures:

Sum of Sales = SUM ( 'Actual Sales'[Sale] )

Sum of Target = SUM ( 'Target Sales'[Target] )

% of Target = 
    DIVIDE (
        [Sum of Sales],
        [Sum of Target]
    )

Then set [% of Target] to format as a percentage and used that measure directly in the gauge:

Your file with modifications

If that's not what you're after let me know and try and unpick.

[RingoSun]

@bcdobbs 

Hi there thanks for the reply! But I still want to be able to have this thing right here

So basically the gauge will be between 0% and 100% and then the indicator will be the target

[bcdobbs]

So just to check you want the gauge aspect to still show as if it was 6000 with a target line at 8000 but the number to read as a percentage?

Will have a play and see what I can do. Not sure if it does it natively but fairly sure we can create the effect at the very least. Will get get back to you.

[bcdobbs]

Is this what you're after?

To achieve it I've taken the original gauge but then then dropped a card with category label turned off over the top with the % measure given above.

You can then group the two visuals so they move as one.