Develop a Dashboard with a User-input Form to Add One-off Data point

[mike_302]

I have some ambition for my dashboard.

My dashboard currently presents data points in a number of formats -- box and whisker charts, stacked bar charts, etc. It gets this data from a central bank of data that my dashboard is linked to, and which is then does a bit of transforming.

I want to give users a dashboard in which they can input their own data point (in the same format as the post-transformed data that is already presented) and see that data point as a unique point overlaid on the existing central data.

Any examples of this type of thing in a dashboard before? Is it possible / reasonably easy to achieve?

The intention here is: The central databank that is linked and transformed to create my baseline dashboard, represents the performance metrics for a wide collection of projects we have on our records. Users of the dashboard might then get metrics for their newer project, and they will want to overlay it on the visuals for the past projects, for comparison.

[Anonymous · Accepted solution]

HI @mike_302,

Did you mean the user operations can affect the backend data tables? If that is the case, you can take a look at the dynamic m query parameters if helps:

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Docs

>>Users of the dashboard might then get metrics for their newer project, and they will want to overlay it on the visuals for the past projects, for comparison.

These visualizations can be updated by user operations, but I don't think it is possible to overlay these on original visuals.

Regards,

Xiaoxin Sheng