Calculating overal percentages from certain values in a column.

[angelojoseph17]

Hey all , 

Fairly new to power bi. 

I have a colum called hrs which lists the number of hours. 

The values in this column ranges from 0-80.

I essentailly want to create a visual showing percentage of rows in that colum which are less than or equal to 1. 

I was going to use a pie chart to demonstrate this. 

Is anyone available to point me in the right direction of doing this. 

Thanks. 

[Eric_Zhang · Accepted solution]

@angelojoseph17

You can try to create a calculated column and use it as the legend of the bar chart. In the Values field, set count of category.

category = IF('Table'[HRs]>1,"More than 1 Hour","Less than 1 Hour")

[Greg_Deckler]

You can switch the Detail labels to have a Percent of total label style and perhaps do binning or grouping to group 0 and 1?