Typically, we need to visualize a enterprise course of in Energy BI. That is difficult, relying on the visualization wanted and once we mannequin our information within the typical means. Let’s see how we will make it occur by altering the modeling.

11 min learn

·

11 hours in the past

Our Enterprise is made up of processes. Some are apparent, like a manufacturing course of, and others are extra digital.

For instance, after I need to calculate the Margin, there’s a “course of” to do it.

In a really simplistic means, after I take my revenue and subtract my bills, what’s remaining is my margin.

My present goal is to visualise this course of in a chart.

The chart ought to show the composition of the Margin as a Course of. For this, I like to point out the values from the Gross sales Quantity to the Margin as a Waterfall.

One thing like this Mockup, which I created in Excel:

I begin with the Gross sales Quantity, and all bills can be deducted till I get the Margin.

There are some challenges to realizing this in Energy BI.

First, I have to change my information mannequin. Then, I can write just a few Measures. Lastly, I can create the visualization.

In the end, I’ll gather details about the information mannequin and its efficiency to evaluate the standard of my strategy.

Let’s undergo these steps.

Firstly, the Normal Waterfall chart doesn’t enable for the addition of a number of measures to construct this chart.

At the very least one customized visible can do that, but it surely’s a paid visible, and I need to go along with the usual waterfall visible. Nearly all of my purchasers are reluctant to purchase customized visuals.

So, I would like to alter how the information is saved to finish the job.