Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
mfarref
New Member

KPI (number) based on a bar chart

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:

mfarref_0-1687158089777.png

 

(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!

3 REPLIES 3
PurpleGate
Resolver III
Resolver III

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)))
 
PurpleGate
Resolver III
Resolver III

You could create a measure, similar to how you probably coloured in the bars.

 

LessThan3 = CALCULATE(COUNTROWS('Table'),'Table'[Amount]< 3)

 

 

PurpleGate_0-1687161511858.png

 

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.