Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Waterfall chart that reinitializes every month

Hi!

I'm trying to create a visual mixing Waterfall charts and stacked column charts features and have no clue how to do this. Basically the result I am looking for is as the joined picture shows. I want to creat a water fall - like visual where every month is independent from the other ones, meaning that I don't want to see the increase/decrease provided by Power BI. In other words, I want a stacked column chart with the stacks looking like a waterfall chart and the total represented individually.

 

The data I have on hand are the following:

- an "Actions" table that gathers every action (1 line = 1 action taken), with the following columns:

     - Name of the actor

     - Action Key

     - Date of the action

     - Type of the action

- A Date table with years and months related to the Date field of the "Action" table (1to*)

 

 

 

No Replies