HOME BI Forums Supply Chain Business Intelligence Power BI How do I allow non-numerical user input?

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #2596
    SGK_ZenMaster
    Participant

    I recently posted about how t size what-if parameters, but now I am running into an issue on how to get user input when there are no numbers involved. I want my end user to select from a list how to display the numbers, either as they are or divided out by the total volume. I already have a field for volume and know how to calculate, but I am stuck at trying to get the options into Power BI. Any help is appreciated!

    #2597
    skastens
    Moderator

    Hi,

    From my experience, creating a table in Power BI with the options you want to display works well. You can use DAX DATATABLE to set up a table with one column for displaying total or by volume. A slicer could be created on this field. In your calculation, you would need to reference the value in the filter using something like SELECTEDVALUE. Hopefully this helps!

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.