Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
JustinDoh1
Continued Contributor
Continued Contributor

How to add drop down / list of selection to one Parameter?

I am shareing PBIX file here.

 

I am trying to find a way to dynamically reduce the number of Parameters that I created from 41 into 1 with a some way to select choices.

 

Bottom is just an illustration of Parameters.

JustinDoh1_0-1679356271782.png

My uploaded/attached file only has two parameters, but in actual PBI files, I have about 41 parameters:

JustinDoh1_1-1679356395410.png

 

What is happening on the PBI file is, depending on the value that I enter at Parameter, value of Forecast Stars would change like 1,2,3,4,5 (depending on input value). 

JustinDoh1_2-1679356515386.png

 

What I am trying to do is: instead of having multiple parameters created (like 41), I would like to just have One parameter with a way to select options like (ART, CAL etc.).

Is it possible logically with DAX?

 

 

10 REPLIES 10
tamerj1
Super User
Super User

Hi @JustinDoh1 
I'm not really sure I understand your requirement. In your original post, the 2nd screenshot shows all slicers selected at 70. If all slicers shall have the same value then the whole SWITCH statement is not required and variable 

_Param shall be the SELECTEDVALUE of the only one slicer that you would need. 
However, I can see that the 3rd screenshot shows different selections (ART is 384 and CAL is 234). In this case what could be the meaning of your question? If each Provider requires different selection then there must a separate selection for each provider. Please clarify.
JustinDoh1
Continued Contributor
Continued Contributor

@tamerj1 Thank you for your comment and your interest on this issue.

 

I have uploaded the updated PBIX file here.

 

So, basically, the number 384 or 234 is not relevant. It is just an example to show in the illustration.

 

The main objective is, instead of having so many parameters, I would like to possibly combine two/more together to reduce visuals.

 

So, whenever user moves a slider, it will also change the value on the "Forecast Stars" together for ART and CAL instead of using each slider separately.

 

As per @wdx223_Daniel , I tried creating a new table called "NewTable1", but I am not sure what to do now. 

I tried with "slicer" visual, and possibly try to join this table ("NewTable1") with a fact table ("tblDataMain"), but I am not sure what else I could do.

 

BTW, "NewTable" is my first approach to mimic what @wdx223_Daniel put on the post using Parameter.

"NewTable1" is a table that I created after using @wdx223_Daniel 's second feedback. 

 

Thanks!

JustinDoh1_0-1686609646852.png

JustinDoh1_1-1686609817961.png

 

 

 

JustinDoh1
Continued Contributor
Continued Contributor

@wdx223_Daniel Hi, I would like to follow up on my inquiry. Appreciated for help.

suggest to integrate your tables  as below

wdx223_Daniel_0-1681097432444.png

 

Hi @wdx223_Daniel 

First, thank you so much for helping me.

I uploaded my PBIX file.

When I used the same code (using Parameters), it generated like this:

JustinDoh1_0-1683925794613.png

Why is it different from yours?
Thanks.

the difference between those two tables is,

you use parameter function to create the table 0-500, and that give it a column name of "NewTable".

@wdx223_Daniel I got it now. Now, the question is how do I integrate this table into visual? I think the table is good, but critical portion is how do I express into visual? What type of Visual should I use?

wdx223_Daniel
Super User
Super User

you can combine your 41 tables into one with a column to lablel ART, CAL.

@wdx223_Daniel Thank you for your help. Is it possible for you to illustrate visually little more / save the updated PBIX file? I tried adding column to an existing Parameter, but it does not seem to work.

@wdx223_Daniel Hi, I would like to follow up on my inquiry. Appreciated for help!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors