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

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.