'Create Bar Charts from a table
I have a table of 4 columns (Sys_ID, User_ID, Test1, Test2)
This table shows many Sys_ID - User_ID combination which has failed either test 1 or test 2 or both. (There wont be a record which has both Test1 and Test2 as "Pass")
Sample table with 8 records shown below:
sys1, user1, fail, pass
sys2, user2, fail, pass
sys2, user3, fail, pass
sys2, user4, fail, pass
sys3, user5, fail, fail
sys3, user6, pass, fail
sys4, user7, pass, fail
sys4, user8, pass, fail
I want to create 2 Column charts in Power BI dashboard from this table as data source:
ColumnChart 1 - Shows a unique list of systems as columns with the counts of users that failed test1 (For the sample table, this column chart would show 3 column for sys1, sys2, sys3 with counts of 1, 3, 1 respectively)
ColumnChart 2 - Shows a unique list of systems as columns with the counts of users that failed test2 (For the sample table, this column chart would show 2 column for sys3, sys4 with counts of 1, 2 respectively)
I am very new to Power BI. Could anyone please point me in the right direction?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|