Forum Discussion
Pie Chart Separating Values in Same Row
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.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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 linkIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
So the issue i ran into by splitting the column by delimeter is that now i will have "duplicate" records. This will affect all my other pages and graphs i have since it will think i have more results in the PQ that it should.
Is there a way in the chart to do a DAX, similar as an Excel formula where if "countif" contains *specific manufacturer* then provide that total?
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:
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
So what i did instead is, i duplicated the main query and split my column there. Then i used the query with the split column to create the chart. It's working fine, so let me know if you see an issue with doing this.