Forum Discussion

shudiniu's avatar
shudiniu
New Member
8 years ago
Solved

Dynamically calculate percentage from user input

Hello,    I'm faily new to the power bi world and currently working on a dashboard that shows the % weights of company's investment in different industry, now I'm trying to add a new feature to let...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi shudiniu,

     

    In Power BI, it doesn't allow users to input any value manually in report view. While, you can use a slicer to list all available values for users to select. To get the user's selection, you can create a measure like this:

    Selected value =
    LASTNONBLANK ( TableName[FieldName], 1 )
     
    Best regards,
    Yuliana Gu
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi shudiniu,

 

In Power BI, it doesn't allow users to input any value manually in report view. While, you can use a slicer to list all available values for users to select. To get the user's selection, you can create a measure like this:

Selected value =
LASTNONBLANK ( TableName[FieldName], 1 )
 
Best regards,
Yuliana Gu