Hello! I have a table with the above 2 columns and I need to show each value from ColumnA in a Stacked bar chart, based on ColumnB:
A (first bar) - data stacked 2(Pass)+2(Fail)
B (2nd bar) - data stacked 1(Pass)+2(Fail)
C (3rd bar) - data stacked 1(Open)
And so on.
Go to Solution.
Using your sample data , See the below soluton .
Drag Col A into x Axis
Drag Col B into into Value ( Select Count from context menu)
Drag col B again into Legend
You can also create a masure to calculate count and use measure instread of col B directly.
Hope it helps
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!