Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello there,
I have created a Power BI visual whose data is direct queried from SQL DB. Is there a way to add user input priority data as a column in the published Power BI visual which doesn't write back on to data source(Just need this user input data at visual level)? I am okay to change the data extraction to import mode instead of Direct query.
Solved! Go to Solution.
Hi @DE001 - Yes, you can add user input data such as a priority column to your Power BI visual without writing back to the SQL database. Power BI provides features such as What-If Parameters and Enter Data to facilitate user input at the visual level.
What-If Parameter:
Go to Modeling > New Parameter > What-if parameter.
Set the parameters as follows:
Name: Priority
Data type: Whole number
Minimum: 1
Maximum: 10
Increment: 1
Default: 1
Click OK. This will create a slicer for priority selection.
Add the Slicer to Your Report:
Drag the newly created Priority slicer to the report canvas.
This slicer will allow users to select a priority level.
SelectedPriority = SELECTEDVALUE('Priority'[Priority], 1)
use the above measure in your visualization.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Hi @DE001 - Yes, you can add user input data such as a priority column to your Power BI visual without writing back to the SQL database. Power BI provides features such as What-If Parameters and Enter Data to facilitate user input at the visual level.
What-If Parameter:
Go to Modeling > New Parameter > What-if parameter.
Set the parameters as follows:
Name: Priority
Data type: Whole number
Minimum: 1
Maximum: 10
Increment: 1
Default: 1
Click OK. This will create a slicer for priority selection.
Add the Slicer to Your Report:
Drag the newly created Priority slicer to the report canvas.
This slicer will allow users to select a priority level.
SelectedPriority = SELECTEDVALUE('Priority'[Priority], 1)
use the above measure in your visualization.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |