problem with creating chart

[Anonymous]

Hi!

I have the following question; 

I have a dataset with 1600 rows and each row contains a value (price) 

Now I want to make a chart that give me the following information: Show me how many values are less than € 1000, tell me how many values are between € 1000 and € 1500, and tell me how many values are above € 1500.

Is this possible? And if so, how can I create this chart? 

Thanks for your response!

Cheers Sander

The Netherlands

[HotChilli]

Add a calculated column (similar to this thread https://community.powerbi.com/t5/Desktop/Help-with-Switch-Function/m-p/681931#M328485 )

Then pull the column on to a visualisation (clustered column chart - put it in the Value well and change the aggregation to count.

Pull the column again onto axis.  The chart should give you what you want.