Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
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%.
can anyone help me?
I just want the percentage to show 70,29% instead of 7029,00%.
Hi @aso1 ,
Your original value is not a percentage. Please divide by 100 before converting it to %.
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?
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!
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].
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").
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.