Slicing Values of Column Into Pie Chart

[Stormborn20]

I have a colume called MissingPatches that I want to slice up into into a pie chart to show individual values ranges, like Missing Patches 1-5, Missing Patches 5-15, etc etc. Any advice on where to begin with this would be greatly appreciated.

[AlexChen]

Hi,

You can do it using calculated column. Please refer to sample below:

I assume you have table called “patchInfo” like below.

Create a calculated column :

Column = if(patchInfo[MissingPatches] <= 5, "missingPatch 1-5", "missingPatch other")

Now you can create a pie chart and slicer to show this.

Best Regards

Alex

[ankitpatira]

@Stormborn20 Go to power bi desktop query editor, under Add Column tab, Conditional column and create conditional column such as if value in your column is greater or equal to 1 and less than or equal to 5 then 1-5 and so on. Then use that conditional column in pie chart as category and your original column as values.