Double Stacked Bar Graph

[Syndicate_Admin]

Hello friends, I need your help, I am new to Power BI and I have a problem with stacked bars, the problem is that I have to 3 measures, 1 measure that is a budget, which goes alone, another measure that is what is spent + what is projected, obviously these 2 measures must be stacked and that are related to the measure of budgets. currently I am graphing the measurements by separators, on the 1 hand only the budget and on the other hand the 2 stacked measures, I have to move the length manually, but when updated, I lose the relationship and it messes them up again. ideally, they should be in a single graph, but I can not leave them as I want. the photo I show is like I need them to be in 1 only graph. grateful from now on with the solutions.

[v-yangliu-msft]

Hi  @Syndicate_Admin ,

Here are the steps you can follow：

1. Use Enter data to create a table.

2. Create measure.

Stacked1 =
IF(
MAX('Table2'[Group])="PPTO",0,[PPTTO])

Stacked2 =
IF(
    MAX('Table2'[Group])="Gastado&&Liberadas",[Gastado],[$ Liberadas S/Fact])

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Syndicate_Admin]

Estimado Liu Yang:

reviewing the steps to follow, I do not know how to create or edit the groups in step 1. you can indicate some forum or video to see the steps, I would appreciate it. thank you now.

[v-yangliu-msft · Accepted solution]

Hi  @Syndicate_Admin ,

Click Home - Enter data. to create a table.

Create measure.

Gastado&Liberadas =
IF(
MAX('Table2'[Group])="Gastado&&Liberadas",0,[$ Liberadas S/Fact])

PPTO =
IF(
    MAX('Table2'[Group])="PPTO",0,[PPTTO])

Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Dear:

The proposed solution is the one indicated, it was what I needed, the only bad thing is that the data was changed. as indicated on the sheet in the example sheet. the PPTO data = 63.8 mm and goes alone. I don't know how to fix it. I could indicate some video or some forum of how I make this solution, I am interested in learning.

https://mega.nz/file/6o4GmQqY#IrXsps7VESQ6b4d9e9_x9Q0Q9XdDFDTTy76BVCHa26k

[VijayP]

@Syndicate_Admin 

It might be possibel based the datamodel one created . For Example if you look at below snapshot

the Table structure created to accomodate values the you want in a single graph for Budget and Actul+Forecast

If you can share the pbix , I may try to help you with more details

[Syndicate_Admin]

Something like that is what I need, I share my pbix, to see if you can help me. I would be grateful. same any suggestion to my model and pbix would appreciate it, it is my first dashboard.

https://mega.nz/file/6l4AyTgJ#-CVsjVclykJtINYQHNjJ1biiIkFcQe3Lihx4YFrNqt8