In Power BI, how to categorize multiple parameter slider bars into different categories which can then be used as slicers?

Vili Sivannarath 20 Reputation points
2023-04-24T22:50:16.2+00:00

In Power BI, I've created several parameter slicers for scenario planning. How do I categorize all of those parameters so that I can create a filter/slicer function? I've watched several videos on how to upload parameters, but they all seem to be data fields to filter by rather than dynamic fields as a result of user input (parameter slider bar). Is this something that can be done within PowerBI or do I need to create separate models in Excel to generate the proper data upload into PBI? Here is a simplified version of my PBI model.

  1. Summary page= table that shows Original Revenue vs. Adjusted Revenue
    1. For Adjusted Revenue, I would like to be able to create a slicer for the Adjustment Types (i.e.; 1, 2) as a result of adjustment #2 and #3
  2. Adjustment 1= increase revenue by x% (Parameter 1 + Parameter 2)
  3. Adjustment 2= increase revenue by x% (Parameter 3 + Parameter 4 + Parameter 5) Each "adjustment" is comprised of several parameters because each has a different calculation but should be dynamic enough to adjust on the fly (i.e.; the multiple parameter slider bars on each page). I've created separate measures to quantify each "Adjustment" revenue which has become problematic when going to create a slicer. Ideally, I want a drop-down slicer of each adjustment type.
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,669 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Hua-MSFT 27,556 Reputation points
    2023-04-25T06:27:42.5+00:00

    Hi @Vili Sivannarath

    To help you better, I suggest you post a new thread on Power BI community.

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


    0 comments No comments

0 additional answers

Sort by: Most helpful