Need the percentage calculation

[NavaneethaRaju]

Hi @amitchandak ,

i created a measure that have target, and the data bars have the acheived counts, i want to show the same values in % wise. 

my target is 57. here 57 is 100%.

I want to show the bar values in percentage.

Please help this.

[v-rzhou-msft · Accepted solution]

Hi @NavaneethaRaju ,

I suggest you to create a measure.

Percentage = 
VAR _VALUE = SUM('Table'[Value])
VAR _TARGET = 57
RETURN
DIVIDE(_VALUE,_TARGET)

Select Percentage Formart in Measure tools.

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NavaneethaRaju]

Hi @v-rzhou-msft ,

the idea that you gave previously its helped, Now i'm facing the issue in same constant line. in previously I'm having only one month of data. Now i'm having 4 months of data. there i created report using your idea, In percentage tab the constant line positions are not matching.

I enclosed the two images, please look into this. 

I need constant line in same as in values tab. Please advice is i need to create any measure for values or constant line.

Note: In percentage page i put constant line values as 1.