Forum Discussion

clim2f88j's avatar
clim2f88j
Frequent Visitor
3 years ago
Solved

Pie Chart Separating Values in Same Row

This is the data columns i have in Power BI:   Client ID Manufacturer 223 Honda 345 Kia 777 VW, Seat 696 Seat 122 Honda, Kia, VW 009 Kia, Seat...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi clim2f88j 
    To achieve your first goal please follow next steps:
    1. In PQ you need to extract your rows with  values to different rows as split by comma as shown at the pictures :

     

    2. You need to Trim the column of manufacturer :

     

    3. Just "close and apply" and put it on your pie chart

    ****

    In terms of data visualization, this type of graph is ineffective and even incorrect for two reasons.

    In the first place, our brain is unable to calculate the areas of segments

    A second and more critical point is that you don't show one part of the whole here. Instead, you rank the parts based on their dominance (percent of all).

    Therefore, I recommend switching to a bar chart, as shown in the image.

     

     

    Link to sample file 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly



  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi clim2f88j  you can use "calculate" for this purpose.
    But that means, you need to create separate measures for every manufacturer.
    Please Follow this step if that is your desire:
    1. Add Column to count words of your manufacturers : ( you will need it for your "ALL")

    2. Than count percent of every manufacturer by formula:

    Percent KIA =
    Divide(CALCULATE (
        COUNTX ( 'Table whithout splitting',[Client ID] ),
        FILTER (
            'Table whithout splitting',
            CONTAINSSTRING ( 'Table whithout splitting'[Manufacturer], "Kia" ) = TRUE
        )
    ) ,
    CALCULATE(sum('Table whithout splitting'[Words Column Counter]),all('Table'[Client ID])))

     

    Then you need to put these measures separately.
    I have updated the Sample file again.
    Here is a link 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Thejeswar's avatar
Thejeswar
Super User
3 years ago

Hi clim2f88j ,

1. Select the Manufacturer Column and Use Split by Delimter to split the entries ("Comma" delimiter to be use with each occurence"

 

2. Post which the data would look like this

3. Now, select the 3 manufacturer columns and click on Unpivot Columns as shown below

 

4. After doing step 3, this is how the table will look

 

5. Remove the Attribute column and rename Value to Manufacturer. PFB the screenshot for the same

6. Select the Manufacturer Column and Trim it using the Format Drop Down to remove any unwanted spaces in the names. This will help iwth grouping the column for getting the count and percentage

7. Get the Count of Manufacturer using the below measure

No of Manufacturers = COUNT(Manufacturer_Table[Client ID])
8. Get the Percentage using the below measure
% of manufacturers =
VAR A = COUNT(Manufacturer_Table[Client ID])
VAR B = CALCULATE(COUNT(Manufacturer_Table[Client ID]), ALL(Manufacturer_Table))
RETURN
DIVIDE(A, B)
 

 

If this helps, mark it as solution to help others. You can appreciate with a Kudo!

 

Regards,