Forum Discussion

KabirDhupelia's avatar
KabirDhupelia
Regular Visitor
7 years ago
Solved

Histogram in PowerBI using numerical data

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. 
 

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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.

     

     

     

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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.