Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello,
I'm new to PowerBI and I can't find a way to generate a KPI (that is a number) based on a bar chart.
My chart is:
(If you need translation from catalan, ask and I will translate anything you need)
I want to create a KPI that returns the number of column with a value below a threshold. I've been able to color the columns differently based on this threshold, but I can't generate a separate KPI.
Thanks in advance!
Is value you are using in your barchart from column or a measure?
If it is a measure, then you can count the number of days the average is less than your threshold.
SUMX(VALUES('Date'[Day]), INT(CALCULATE([Mediana de Temps buit] < 3)))
You could create a measure, similar to how you probably coloured in the bars.
LessThan3 = CALCULATE(COUNTROWS('Table'),'Table'[Amount]< 3)
The value of the columns is an average of a column from the table per day. How would that work? I don't now if this is a very basic question, but I'm really new in PowerBI
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
8 | |
8 | |
4 | |
3 |
User | Count |
---|---|
15 | |
15 | |
11 | |
10 | |
10 |