Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Double Stacked Bar Graph

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 t...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

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.

pbastidap_0-1646703167835.png

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