Forum Discussion
Pie Chart
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.
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 They are not important for the time being.
First thing i've did is replace the BLANK value by 0. Then everything that looked like TEXT TYPE I turned it into NUMBER.
Example : 15.00 : 15Example : 7.50 : 7,5
Then
I went back to the pie chart :
Under Filter : Visual filter level
I add Partial String testing (NOT the number of Partial string testing, only the field)
I choose advanced filter > Superior or equal to > 100
You do that for every other value and it will work fine.
- Quentin
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.
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.