Forum Discussion

phaum1967's avatar
phaum1967
Icon for Resolver I rankResolver I
7 years ago

Waterfall dynamic between two months with a segment

Hi everyone I m doing a page with a segment in which I choose a month (formated YYYY-00)   I would like to add a waterfall between this month and the previous one.    It need so to calculate pre...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi phaum1967 ,

Could you please share a simple sample file to have a test due to it is hard to represent your data structure and could you please post your desired result if possible?

 

Regards,

Daniel He

  • phaum1967's avatar
    phaum1967
    Icon for Resolver I rankResolver I
    7 years ago

    Hi Daniel,

    this is what I want: In a segment in power bi page, I choose a month then It will select in table all items in this month (it will have more than one data for an item so sumx is needed I think.

     

    And it will sum all data before the month to have initial amount.

     

    Hoping this will be more clear ;-)