cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

data entry in a visualization in your report

Hi all,

I have a report that I use for several companies.

Each company has different FY and data set and we add those in parameters to set it up quickly.

 

One of page of my report is for actual vs target with 6 different gauge vizual.

 

Instead of manually set up target directly in the format of each visualization, could I have the manager type it in a set-up page so it could be reference to by a parameter or a measure that would be in the visual.

 

Hope my message is clear enough

 

Thank you for your help 

1 ACCEPTED SOLUTION

@Cofinia,

 

Try to add a table and create relationship, then a slicer might be helpful.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Microsoft
Microsoft

Have you considered using Query Editor parameters?

 

You could offer a series of these to the report user which drive some Query Editor functions around date start/end ranges etc


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Hi Phil,

Thank you for helping me.

Yes I tought of it, but I want to keep it really really simple for the user.

I was wandering if I could add tile to the first page of the report and have the user enter a value that I could then push to the parameter.

I would not want the user to go into desktop to add parameters

@Cofinia,

 

Try to add a table and create relationship, then a slicer might be helpful.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

HI

I thought about that yesterday.

I'm going to add an excel spreadsheet so the can enter the numbers and I will add this file to my data model.

Thank you for your help

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors