Numerical Slicer - need to display 0-100% of a numerical value.

[dskinner8]

Hello,

I need to implement a numerical slider that shows the % of a particular column value. 

Say for example I have a column called Sales Amount, the sum of which is , $150 000, I need the numerical slicer to range 0 to 100%, which shows the % of this Sales Amount.

 

So with the slicer at 100%, the value displayed (in a card or something) would display  $150,000. Dragging the slider down to 50% would bring the value down to 75,000 showing all the different percentages of the Sales Amount in between when dragging. 

I have a drop down slicer as well for each different row, so when one is selected (with for example a sales amount of $130), the percentage slicer still needs to be 0 to 100, but the Sales Amount would be just for this specific row, so 100% would obviously be $130. 

This is my first time ever using Power BI, any help would be greatly appreciated.

[v-shex-msft · Accepted solution]

Hi @dskinner8,

You can simply add a calculate column to calculate the percent and use it a the source of slicer.

Percent = [Amount]/MAX('Table 2'[Amount]) 

Regards,

Xiaoxin Sheng