Histogram in PowerBI using numerical data

[KabirDhupelia]

Hi

I have data which is structured as follows. I need to create a histogram showing prices (prices are in R per R100. Example, Bob pays R18 600 for a R6 000 000 transaction, this equates to a revenue rate of R0.31 per R100.)
The histogram needs to have prices on the x axis, and the number of clients 'per price'. How do I go about doing that? Because my price is calculated as a measure, I can't bring it into a non value field. 
 

[v-frfei-msft · Accepted solution]

Hi @KabirDhupelia ,

One sample for your reference. Please check the following steps as below.

1. Creat two calculated columns as below and format them as number. 

Rev = RIGHT('Table1'[Revenue],LEN('Table1'[Revenue])-1)

val = RIGHT('Table1'[Value],LEN('Table1'[Value])-1)

2. New another calculated column.

Price = 'Table1'[Rev]/Table1[val]

Pbix as attached.