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.
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
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |