cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gracechong
Helper I
Helper I

Measures to create dynamic visualisation that changes based on two run dates selected in filter

Hi,

 

I am trying to create a Power BI visualisation that is able to provide (1) year on year and (2) daily movement in both value and % when I select different run dates from the filter. Basically the whole dataset will have a few run dates across few different years and I need to be able to compare them based on the selected run dates.

I have tried creating a new date table; to form the relationship to the main data table so that it can be used for filter but it doesn't seem to work. I am not sure how what kind of measures or how to approach it further so that this can be achieved. Would you be able to advise?

 

Below is an example of how the main data structure looks like. 

AccountAccount TypeAccount  Type 2Account DescriptionCodeCode Type 1Code Type 2YearMonthOwnerRun dateAmount
AssetCurrentCashCash on Hand15463AWES1202105Ram31 May 20211000
AssetNon CurrentBankCash in Bank35671AWSS2202105Ram31 May 20215000
ExpenseOperatingGeneralGeneral Cost65542ERTT6202105Mary31 May 2021300
ExpenseManufacturingDirectDirect Manufacturing78953EPBT7202105Mary31 May 2021200
AssetCurrentCashCash on Hand15463AWES1202105Ram29 May 2021200
AssetNon CurrentBankCash in Bank35671AWSS2202105Ram29 May 2021200
ExpenseOperatingGeneralGeneral Cost65542ERTT6202105Mary29 May 202150
ExpenseManufacturingDirectDirect Manufacturing78953EPBT7202105Mary29 May 2021100
AssetCurrentCashCash on Hand15463AWES1201905Ram31 May 20195000
AssetNon CurrentBankCash in Bank35671AWSS2201905Ram31 May 20197000
ExpenseOperatingGeneralGeneral Cost65542ERTT6201905Mary31 May 20192200
ExpenseManufacturingDirectDirect Manufacturing78953EPBT7201905Mary31 May 20193000
0 REPLIES 0

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors