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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

How to add a Dropdown Parameter to My Report That is Independent of all Other Filters

Hello,

I need to add a drop down slicer to my report that acts similarly to the Modeling Parameter. On my report I need a user to be able to single select a location from that slicer and then have that selection return a variable that can be used in an equation. Is this possible and if so how have you achieved this?

Thanks All.

5 REPLIES 5
v-janeyg-msft
Community Support
Community Support

Hi, @Anonymous 

 

According to your description, I think there is no problem with your logic and approach. But in the end, you can't change the measure into a calclulated column. You should know that only the measure can change dynamically.

If you still need help, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous
Not applicable

Can you share an example of what you mean? 

you could try a lookup based on the selected value and do a calculate function. 

example 

Lookup([Variable],variabletabke[location],selectedvalue(dim_location[location])*result your adjusting by variable 

Anonymous
Not applicable

Below is a cleaned up version of my report what I need to do is have the Metropoliten Area slicer uner the Input Values section be completley independent of the rest of the report (curently that slicer goes to a table that has no relations to my other data) and return the appropriate Index value for the area selected.  I will need the value to adjust the AVG_UC_TM column at the bottom of the page. 

 

 

Power BI Report 1.jpg

 

Location Index.JPG

amitchandak
Super User
Super User

@Anonymous , Independent table what if can work like that. Based on What I got from your description

 

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

 

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Anonymous
Not applicable

I tried what you were sugesting in the recomended video and I was still having issues.  Below is essentually the quation that I am trying to create. 

 

Average UC Location = AVERAGE((RS_Means_Location_Based_Index_Sort[Proposed_Location]/DB_Est_Costs[Location Index])*DB_Est_Costs[UC_TM])
 
The Issue I am running into is that RS_Means_Location_Based_Index_Sort[Proposed_Location] is part of a peramieter what if made up of the following equation: 
Proposed_Location = SELECTEDVALUE(RS_Means_Location_Based_Index_Sort[Index]) 
 
So Idealy I would have a column for  (RS_Means_Location_Based_Index_Sort[Proposed_Location]/DB_Est_Costs[Location Index])*DB_Est_Costs[UC_TM]) and a measure for the average portion.  But when I do it that way the column comes back as blank cells.  

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.