Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

stack bar chart

Hello, I have to create a Stacked bar chart shown in the picture, which shows data from the last 30 days last 60 days, and so on. and I am uploading the data sample too.  I have tried a lot by c...
Need Help
Show and Tell
Tips and Tricks
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

I assume you have the below grouping table.

Please check the below measure.

Once the below measure is inserted into the visualization, then you can segment by group column in the grouping table.

If it is OK with you, share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.

 

 

 

Values Total by group =
SUMX (
FILTER (
VALUES ( 'Calendar'[Date] ),
COUNTROWS (
FILTER ( 'Group', [Days Open] >= 'Group'[Min] && [Days Open] < 'Group'[Max] )
) > 0
),
[Values Total]
)

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,  Jihwan_Kim thanks for answering. No, I don't have such a grouping table. and the visual I have shared here is not from PBX. probably in excel. this is a sample I have to create the same thing in Power BI. 

so can you describe to me how I can create this grouping table?

 

Thanks 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Anonymous 

    Thank you for your feedback.

    You can create the grouping table exactly the same looking as the above picture that I attached.

    If you can share your sample excel file's link here, I can try.

    Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi, Jihwan_Kim , Thank you for your reply. 

      This grouping table can be created by using a new table? and unfortunately, I don't the axis. 

      Before posting this query I tried creating 4 conditional columns in PBI and then created the stacked graph. but it didn't work.  I am attaching the screenshot of the columns.

       

      please have a look.

       

      Thank you. 

       

       

       

       

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi, Anonymous 

        You can create the grouping table in excel and import it.

        Or, you can create the grouping table in power bi manually, like what you do in excel.

        It is only a small-size table, and I think there are not many difficulties in creating the grouping table.

        And this grouping table already has all the conditions you need. So, you can just simply use this grouping table as a filtering condition.