Forum Discussion
Need help Power BI report
Hello Experts,
I am very new to power BI and I need to create a report like as shown below:
Please help me out as I am struggling since days so I thought I could get helo from here.....
My first List is as Teams Created :
My Second List is as Archived Teams:
And the result Should be like this as shown below:
Hi Kiyaan0712 ,
You can follow these steps to try:
1. Create a Date table and create relationships between table 'Teams' and table 'Arcs'
2. Create a count measure like this:
Team Created = COUNTROWS('Teams Created')Arc Created = COUNTROWS('Archived Teams')3. Create a matrix visual and put the Date field in the rows and the two measures in the values, you will get the result like this:
Here is my sample file hopes to help you, please try it: PBIX
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
v-yingjlCommunity Support
Hi Kiyaan0712 ,
You can follow these steps to try:
1. Create a Date table and create relationships between table 'Teams' and table 'Arcs'
2. Create a count measure like this:
Team Created = COUNTROWS('Teams Created')Arc Created = COUNTROWS('Archived Teams')3. Create a matrix visual and put the Date field in the rows and the two measures in the values, you will get the result like this:
Here is my sample file hopes to help you, please try it: PBIX
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Yingjie Li, I followed the steps mentioned by you and its working. Once again thanks to all for helping me out.
jstormResolver III
Do you have a 'Dates' table? Have you created relationships between these tables?
Yes both the table has one common Date field (ActivityDate)
- jstorm
All you need to do is drag the fields you want into a table or matrix visual. So you need 'Dates[Month]', Count of 'Team Created', Count of 'Teams Archived'.