Dynamic dating diagram
It generates a random number between 1 and 5 in each row for the [Units Sold] column.
The third column [Month] is the start of the month value relevant for each [Date].
For example, to instantly diagram the path of an application, users can just enter the source and destination addresses.
In this fashion, a dynamic diagram is like GPS for the network - instead of an atlas of maps, users can get a customized map from simple input.
We’ve come a long way from hand-drawn network diagrams.
Advancements in diagramming software have allowed engineers to spend less time documenting their network and more time performing important network management tasks.
A recent post on a community.forum asked if it was possible to show a slicer of months, and configure a report so when a user selects a single month from the slicer, visuals will show data for a date range relative to that selection e.g. If a user selects March 2017, visuals will display a date range between May 2016 and March 2017.
Power BI Desktop may attempt to link the two tables, so delete the relationship if this happens. This variable could be substituted with a What-If parameter if you’d like to provide more flexibility to your end users.This is the column we will use in the axis of a visual.This code can be tweaked a number of ways to control when the data table starts and finishes, how many rows per day, as well as the parameters for the random number used for [Units Sold].The final piece of code is to create a calculated measure based filter that will be used to help select the date range. The Data Table Date variable will store the minimum value of the [Date] field from the ‘Data Table’ for each bucket on the axis.This will effectively control which rows from the ‘Data Table’ table will be used by the calculated measures on the visual.