Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I have three columns of categories (with associated dates) that I would like to get a count of, by quarter, and then make a stacked bar chart.
The data looks like below:
Date Embedded Applicable SentOut
1/12/18 Yes No Yes
1/15/18 Yes Yes Yes
.
.
.
3/23/19 No No No
I would like to make a stacked bar that would have the quarters of each year on the x-axis and a bar that shows how many 'yes' occurred in each category (embedded, applicable, sent out) for each of the quarters.
I have already made a column that corresponds to the quarter of the year, but am at a bit of a loss on how to proceed. Some hints would be very very much appreciated!
@annaY - You need a DAX Measure for each category like this:
Count Embedded Yes = COUNTROWS(FILTER(<YourTable>,<YourTable>[Embedded]="Yes"))
Then you can add all 3 Measures as Values in your chart.
Cheers!
Nathan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |