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 reve...
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.

     

     

     

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.