Forum Discussion

Colinu's avatar
Colinu
Helper I
8 years ago
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 ...
Need Help
  • Colinu's avatar
    Colinu
    8 years ago

    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.

     

Hardik's avatar
Hardik
Continued Contributor
8 years ago

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
Preparations1
a 0
b c12
d4
Colinu's avatar
Colinu
Helper I
8 years ago

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