Forum Discussion
Solved
Pie Chart
Hi All i need some help with a pie chart. I have a data set that contians data that is not equal in value, see image The outcome i am looking for is: A 5 segmented Pie chart of equal ...
Sorry but i am doning somthing worng here or it is not working for me.
please see below screeen shot.
in this instance i have followed you instructions.
Added a filter to the Pie chart so it only shows CableID 2
then added the filter to Partial string test >100. the value in the filed has been adujsted in the data set to 99 so is should not show. when i apply this filter the whole chart disapears.
how do i do that?
You can go to the data tab > Power Query editor and copy the 10 first line of your datas for example
If you have sensitive data, post a dummy sample
- Quentin
hi thanks
i can share it but i cant see how i attach it to the post on here?
String Cable ID Size Tower Pre-term Testing Preparations Terminations Post term testing Partial string testing 2 1 15.00 20.00 15.00 5.00 100.00 AB01 - AB05 AB01 7.50 15.00 5.00 100.00 AB06 - AB02 AB02 7.50 15.00 5.00 100.00 AB02 - AB01 AB02 5.00 15.00 5.00 100.00 AB08 - AB03 AB03 5.00 15.00 5.00 100.00 AB03 - AB04 AB03 5.00 15.00 5.00 100.00 AB03 - AB04 AB04 5.00 15.00 5.00 100.00 AB01 - AB05 AB05 15.00 5.00 100.00 AB11 - AB06 AB06 15.00 5.00 AB06 - AB02 AB06 15.00 5.00 AB12 - AB07 AB07 15.00 AB07 - AB08 AB07 15.00 AB07 - AB08 AB08 15.00 AB08 - AB03 AB08 15.00