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.

     

Colinu's avatar
Colinu
Helper I
8 years ago

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

Colinu's avatar
Colinu
Helper I
8 years ago

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.

  • quentin_vigne's avatar
    quentin_vigne
    Solution Sage
    8 years ago

    Colinu

     

    Can you share a sample of your data ? 

     

     

    - Quentin

    • Colinu's avatar
      Colinu
      Helper I
      8 years ago

      how do i do that?

      • quentin_vigne's avatar
        quentin_vigne
        Solution Sage
        8 years ago

        Colinu

         

        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