Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 size even if the data is not
The segment to be blank / white if the value if less than the current values in the above data set
Each segment to be a diffrent colour from the other.
Solved! Go to Solution.
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.
Hi @Colinu
This job can be done with calculated column and IF
What you should is :
1 - Create a calculated column that = 1 (So that every segment will look the same size) and put your real data value in the tooltip area so that when a user wants to see the data he only have to put his mouth hover.
2 - Control on colors are tricky but if you don't want to show it, simple add a visual level filter : Your Value is greater than 'input value' (not exactly what is down below but you will have the option to put greater than)
3 - And you can choose the color in the data color section in Format
- Quentin
Thanks Qunitin
i am not quite sure i understand.
if all values become equal to 1 then the segments will be equal however i cant then filter on the visual as the values are always 1.
Colin
I have created the columns but then i cant filter on a count and if i try to sum or any other option then the i get no value in the field.
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 |
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 : 15
Example : 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.
You have to add the real value to the filter, not the new column that's equal to 1
- Quentin
hey why dont you create a column for the categories defined in different columns so that your pie chart is depicted on the basis of the values
Category | Value |
Pre term testing | 5 |
Preparations | 1 |
a | 0 |
b c | 12 |
d | 4 |
Thanks.
The data is synced into a SQL table and then brought into Power BI in this format. i can do much in the way of changing it at source.
i have managed to get the equal segments now thought a Count of values. However i can seem to apply a filter to this to not show item that are not equal to the maximum amount.
Filter example.
if the value of pre-term-testing is less than 15 then don't show or colour white
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |