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
I'd like to display the action PercentCompleted field in a bar chart.
But, i have the count value
does anybody know how to remove this "count" to display the value ?
thank you for helping a beginner
Solved! Go to Solution.
thanks @MFelix and @v-yulgu-msft for your ideas.
I've just found the solution. I had to convert the percentCompleted field into percent, and it works.
Event if the field is a numeric value in the SharePoint list, I feel it is converted into text.
thanks @MFelix and @v-yulgu-msft for your ideas.
I've just found the solution. I had to convert the percentCompleted field into percent, and it works.
Event if the field is a numeric value in the SharePoint list, I feel it is converted into text.
Hi @forest,
Is the data type of [PercentCompleted] field numeric or text? In a chart visual, Y-axis only supports numeric values. If adding a text field into Y-axis, it will be counted automatically. Besides, any numeric field added to Y-axis should be aggregated by default. You can choose the aggregation format by clicking the drop down icon.
If you don't want to aggregate the field, as a workaround, you can create a measure to return relative results.
Regards,
Yuliana Gu
Hi @forest,
If you have the version after July you can easaly do this by double clicking the values and then giving it an alias check this link.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |