How do I allow non-numerical user input?

[Agillitics]

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!

[Agillitics]

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!

[Author]

Posts