'm designing a dashboard in Power BI for the major projects team in a mining company. I have several tabs within that dashboard, one for a project summary, one for cost performance, one for schedule performance, etc.
I will be building in a project selection screen at the start of the dashboard, which allows the user to filter the visuals in each tab to represent a particular project and data from or up to a particular reporting month for that project.
I'd like you to help me build in measures in PBI for each of the visuals when I prompt you so that the desired visual output is produced for each of them. For example, Id like to create measures that :
Filter a visual with months on its X-axis to show data only up to the reporting month chosen in the project selection screen
Populate a Monthly Variance column by subtracting the previous reporting months variance from the variance of the reporting month chosen in the project selection screen
