How to input a value into powerBI to manipulate loaded data?

Question

I am working on a powerBI dashboard and have hit a brick wall. I have an excel sheet that is dynamic and shifts all based off of one given value. Is there a way I can use this sheet loaded into powerBI, but have a parameter or other form of input change the given value so that all the other values change as well?

Answer 1

You can use parameters in Modeling. Did you test it?

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if

Answer 2

Power Bi is not currently supported here on Q&A. We recommend browsing or searching the Power BI documentation for answers to your question - https://learn.microsoft.com/power-bi/

The product group for Power Bi actively monitors questions over at https://community.powerbi.com/

--please don't forget to upvote and Accept as answer if the reply is helpful--

Answer 3

As Vahid notes, you can embed variables into Power BI reports using parameters. The below article is where I started learning about the concept.

Additionally if you want your parameter values to be referenced instead in the PBI model/DAX calcs you need to right-click "Enable Load" the parameter query in Power Query Editor which will load it into the report model for creating relationships and/or referencing in calcs.

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/