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
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.