cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WLFRD
Helper II
Helper II

Stack sum of 0 and 1 in bar chart

Hello,

 

I would like to use a stacked bar chart to display the ratio between 0 and 1. I would like to use a date slicer to set the enter date. It has to count the 0 en 1 for the chosen period and show the sum of 0 and 1.

5fba2bd3-aa67-4f8b-b689-26319707af60.jpg

 

Result will look something like this:

Capture12.JPG

This is an example which I found on the internet.

 

I gave it a shot but it's not what I would to have:

Capture13.JPG

 

Capture14.JPG

 

So for the given time span based on the date slicer, the has to sum the 0's and 1's and stack them in a bar chart. 

 

How can I do this?

 

Thanks in advance.

 

Regards,

 

 

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @WLFRD ,

 

For this you need to make the countrows instead of the sum try using something similar to this:

 

Total 0 = COUNTROWS (FILTER(Table, Table[Column] = 0))
Total 1 = COUNTROWS (FILTER(Table, Table[Column] = 1))

 

Now use this two metrics on your visualization.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User
Super User

Hi @WLFRD ,

 

For this you need to make the countrows instead of the sum try using something similar to this:

 

Total 0 = COUNTROWS (FILTER(Table, Table[Column] = 0))
Total 1 = COUNTROWS (FILTER(Table, Table[Column] = 1))

 

Now use this two metrics on your visualization.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.