Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Members,
I am new to power BI and need an help to build a visualization:
Below are my two tables :
TestCases | ||
ID | Title | Identifier |
1 | Title1 | x |
2 | Title2 | y |
3 | Title3 | x |
4 | Title4 | y |
5 | Title5 | x |
CoveredTestCases | ||
ID | Title | Identifier |
1 | Title1 | x |
2 | Title2 | x |
3 | Title3 | y |
I want to build clustered bar chart based on identifier (x,y) as total (count of x,y in TestCases table) vs covered (count of x,y in CoveredTestCases table).
something like this as per below screen shot :
Looking forward your quick help here.
Thanks,
Rahul
Solved! Go to Solution.
Hi @Rahul66303,
Create an extra calculated table:
New Table1 = UNION ( SELECTCOLUMNS ( TestCases, "TestCases", "TestCases", "Identifier", TestCases[Identifier] ), SELECTCOLUMNS ( CoveredTestCases, "CoveredTestCases", "CoveredTestCases", "Identifier", CoveredTestCases[Identifier] ) )
Drag corresponding fields from above table into bar chart visual.
Best regards,
Yuliana Gu
Hi @Rahul66303,
Create an extra calculated table:
New Table1 = UNION ( SELECTCOLUMNS ( TestCases, "TestCases", "TestCases", "Identifier", TestCases[Identifier] ), SELECTCOLUMNS ( CoveredTestCases, "CoveredTestCases", "CoveredTestCases", "Identifier", CoveredTestCases[Identifier] ) )
Drag corresponding fields from above table into bar chart visual.
Best regards,
Yuliana Gu
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |