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

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Anonymous 

    Sorry that I could not find the link before.

    Now, I see the link. However, it asks to enter a password.

    Please kindly check.

    Thank you.

     

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi, Anonymous 

        Thank you for sharing the data.

        Please check the below picture and the pbix file's link down below, whether it is what you are looking for.

        It is quite difficult for me to fully understand your case because there is some blank information inside the table. 

        And I want to suggest try to write measures and put measures into the visualization, instead of only pulling the actual column (=number type column) into the visualization.

         

         

        https://www.dropbox.com/s/u5pzrdyz3r2fogn/pbx%20file.pbix?dl=0 

         

         

        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