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,
I trying to do something which I was easily able to when I was using an excel as a data source but now we are using live data from the database and I really need some help.
I am trying to get a similar layout which I had when using excel sheet (these were different columns in my excel sheet so it was easy to create individual visual cards)
This is the output from the database - I have to get this using two tables
1. Roles = names
2. Prsn_ID = Counts of those roles.
I really cant figure out how to have an individual visual card for each role and have the count for it like I could when my data source was just an excel sheet. Maybe need to create a measure? any suggestions and details on how to achieve this.
Solved! Go to Solution.
Hi @Anonymous
I don't think that you will need to create measures to achevie what you have explained in you post.
You can see the solution demonstration below.
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
Hi @Anonymous,
For measures, you can try this:
Athletes = CALCULATE ( COUNT ( table[Prsn_ID] ), FILTER ( table, table[Roles] = "Athletes" ) )
Best regards,
Yuliana Gu
Hi @Anonymous
I don't think that you will need to create measures to achevie what you have explained in you post.
You can see the solution demonstration below.
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
Hi Rexra,
See these images and tell us if works for you.
This would be amazing if I can display the data like this...It is exactly how Im trying to display them individually in boxes
What would I need to do for this?
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |