Multiple Linear Gauges from one list

[valyno]

Hello,

I am looking for some advice.

I need to build a dashboard to follow-up on the expenses of a set of employees (between 1000 and 2000).

The report has a line per expense. Each expense is engaged against a Purchase Order (PO) number. We have several POs. Several expenses are engaged against the same PO.

Each PO has it's defined amount. Once the expenses have reached the total amount of the PO, we need to open a new one to be able to engage new expenses for our employees.

I have a dedicated table listing the POs and their total budget (or envelop). I also have defined in this list of POs a treshhold amount where the user need to start opening a new PO because the current one is about to be totally used (let's say 85% of the budget of the PO).

We have a lot of expenses and a lot of POs.

I would like to have a visual which is able to present a gauge for every PO number:

- Total amount of the PO (from the PO table)

- Total amount of expenses against this particular PO number

- treshold for new PO creation process to start

It would like this a bit (I have not been able to insert the trashold):

Light orange is the total amount of the PO

Dark orange is the total of the expenses engaged against this particular PO

I know hot to build a visual for 1 PO, but considering that we have douzains of POs, with new ones being created during the year, I need to have a visual that would create the bars automatically for each PO number in the lisst of the PO table.

A bit like this:

Creating a linear gauge for each PO manuallu is not sustainable considering the long list of POs and the frequency new POs are added.

Is it possible to achieve what I am looking gor with PowerBI?

I thank you in advance for your help!

Best regards,

Valéry

[parry2k]

@valyno you can achieve this by SVG visual, check this link