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

The 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.

Reply
DE001
Frequent Visitor

Power BI: User input onto published visual

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.

1 ACCEPTED SOLUTION
rajendraongole1
Super User
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!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
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!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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