3 Comments
- Michael_LaneNew Member
A reasonably valuable use case for this functionality is for portfolio management. Using a scatterplot, 3 dimensions (x, y, bubble size) and color can be used to clearly, visually indicate which projects are highest value and move the needle the most, in an easy to understand manner. But what is often needed is also a cutoff line, a line that crosses both axes diagonally. Projects above/to the right of the line are worked, and projects to the left and below the line do not have enough added value, urgency, ROI, or whatever criteria is being used to evaluate the projectsin 2 dimensions, to be worked.
With the diagonal line, we can condense information that make take pages and pages to share in a different format, into a single, easy to understand one-page format that facilitates 15 minute reviews with C-level stakeholders, vs. hours of sometimes strained conversation to explain the portfolio status, approach and next steps.
As mentioned by Marlese, it is possible to place a static line and rotate, but that can be an endless chore of updates as the project list changes.
- lea_calvinNew Member
I have another use case. I have a scatter chart for actual versus predicted values. The users are not interested in showing the trend line, but they do want a diagonal line thru center (x = y) - I was not able to create the line, but at least I was able to use the Symmetry Shading option under the Analytics tab. However, they also need error band mean lines, which is basically the standard deviation calculation. For example, if the standard deviation of the selected data is 105, they would like to see diagonal lines at 105 intervals on each side of x=y (up to 3 sets). The equation for the first set of lines would be y = x + 105 and y = x - 105, the equation for the 2nd set of lines would be y = x +210 and y = x - 210, and for the 3rd set y = x +315 and y = x - 315. I tried doing a screen shot, but it will not let me paste it from my clipboard.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Power Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes3 hours agoNew MemberNeed Clarification197Views3likes1CommentParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v3 hours agoCommunity ChampionNeeds Votes36Views2likes1CommentExpose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_3 hours agoNew MemberAbandoned23Views0likes2CommentsExpose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer5 hours agoAdvocate INew1.2KViews26likes2CommentsImprove relationship visualisation in Model View for large semantic models.
When working with complex models containing many fact and dimension tables, relationship lines frequently cross and overlap, making lineage difficult to follow. A useful enhancement would be to allo...jcheeseaos6 hours agoNew MemberNew12Views0likes0Comments