Unable to Visualize Measure

[Kavya123]

Hi Everyone,

I am unable to show measure in bar chart.  I need to use format for my calculation. Please help

if(HASONEVALUE(Merge1[ResponseType]),format( divide(CALCULATE(SUM(Merge1[Value]) ,FILTER(Merge1, Merge1[Benchmark (2).iIdConsortium]= 52) ),100),FIRSTNONBLANK(Merge1[ResponseType],1)) , sum(Merge1[Value]))

[amitchandak]

@Kavya123 , is format function is going to convert this into text. because if the data type is text, you might not able to use the same on the bar.

[Kavya123]

Response type, Value,Year,Name,Output

##0,  44,  2018  , A, 44

###,###,###,##0%,  50.6,  2018,  B,  51%

###,###,###,##0.0,  66.87,   2019, C, 66.9

###,###,###,##0.0%, 10.7, 2020, D, 10.7%

###,###,###,##0.00%, 30.55, 2020, E, 30.55%

[Kavya123]

Thanks for your response. But, I need to format the data based on the field response type. Please let me know if we have  any other option

[amitchandak]

@Kavya123 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.