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.
I have a table with Employee name, tasks, % completion
I want to visualize it in pie chart.
Employee name as Legend, tasks as details, % completion as values.
However, when I put % completion in values it is converted to "count of % completion" . I wanted to presented as it is without aggregation.
Solved! Go to Solution.
Hi @Haya ,
For the numeric data, there is default aggregation to display the value. To render the original value of % completion , you can right click to choose aggregation "Sum", turn on "Detail labels", choose "Data value".
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Haya ,
For the numeric data, there is default aggregation to display the value. To render the original value of % completion , you can right click to choose aggregation "Sum", turn on "Detail labels", choose "Data value".
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-xicai it was helpful.
However, it ignores the rows with "0 % completion", is there a way to visualuze tasks with 0 %completion?
Hi @Haya ,
You may try to enable the option "Show items with no data" in following location.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can take the completion values and make its how value as % of GT. Right click the value, then you will find it there
Thanks for your response @mussaenda
it makes it "GT of count % Complete"
So it is not the solution. it still use count.
@Haya ,
What is data type of %Completion field? Make sure it is in Numeric value(Whole Value or Decimal value).
Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!
It is Decimal Number.
Format: Percentage
hi @Haya , if it's a percentage already, where is the value it was computed?
that what you need to put in values and show values as % of GT.
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 |
---|---|
106 | |
96 | |
79 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |