Gauge to show data from a column which has two values?

[pmjwhelan]

Hi

Im a Power BI newbie 🙂

I have 55 rows of data and "Column1" is either "Promoters" or "Passives"

I want to show a gauge of the data.

I think 45 are Promotors and 10 are Passives but I'm seeing this ....

Thanks

P

[amitchandak · Accepted solution]

@pmjwhelan , A pie will split gauge will not,

You have to create a measure

countrows(filter(Table, Table[Column1] = "Promoters") )