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 

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]
    )

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi, Jihwan_Kim 

      I am really sorry to bother a lot. but I am a newbie in power BI. 

      I created the table but to use it I need to link it with my existing data model, right? how I join both tables? because I can not create the measure in the group table because the date and open days are in a different table.

       

      Thank you so much.  

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi,

        As I mentioned, if you can share your sample file, it will be much easier to understand by seeing what I can suggest doing in PBI Desktop than just reading words without any sample data. I failed to create sample data based on your explanation. If it is not allowed to share your sample data, then please create one by excel. Thanks.