Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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*)

 

 

RD2023_0-1674664150212.png

 

0 REPLIES 0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.