Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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*)
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |