Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
@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.
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%
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
@Kavya123 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |