Show disks which are under 10% free-diskspace

[aso1]

Hi. 

I am fairly new to PowerBI and need some help.

I have this report that shows a computers filter in left side... and data on right side. 

How can I make a filter, where I can get shown only computers/disks with where PercentFree is below "10" ?

Do I make a calculated column, a measure, ? sorry for the newbie question)

[aso1]

My datatype for percentage column was set to Decimal. 

I just changed it to Percentage. 

But the decimal values are not showing correctly

the top one is showing 7029,00% - but it should be 70,29%. 

[aso1]

can anyone help me? 

I just want the percentage to show 70,29% instead of  7029,00%. 

[v-eachen-msft]

Hi @aso1 ,

Your original value is not a percentage. Please divide by 100 before converting it to %.

[aso1]

thanks a lot!.. 

I divided the original column by 100 and added a percentage type. now the column looks fine. 

however, now the report looks weird. it is not similar to the column. 

what am I doing wrong?

[aso1]

Thanks both for detailed replys.  I think I didnt explain well enough.

What I would like is to have a filter on the left side, right below the 'computers' filter. 

that filter should say "show computers below 10% free-diskspace. 

when that button is pressed, it should show only computers where free-diskspace is < 10%. 

otherwise, the list should be complete as it is. 

Not sure how to accomplish that. 

I've played around with conditional formatting, which works great. I just want the filter-function in the left side as well. 

thanks once again!

[v-eachen-msft]

Hi @aso1 ,

I noticed you have already got a percentage column, you could use filter pane to get results you want.

If you want a measure, you could refer to the following measure:

Measure =
CALCULATE (
    SELECTEDVALUE ( 'Table'[PercentFree] ),
    FILTER ( 'Table', 'Table'[PercentFree] < 10 )
)

Then use this measure to replace [PercentFree].

[lbendlin]

click in the right visual (the table) and observe the filter panel - it will now show "Filters on this visual"  with the fields in the table as possibe filters. Select the PercentFree dropdown and specify your filter criterion ("Less than 10").