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 

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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      hi, Jihwan_Kim 

      can you please explain how can I use it in the filtering condition?

       

      Thank you. 

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi,

        As I already mentioned in the previous reply, you can create the measure below.

        And put the measure into the visualization.

         

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