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 have a scenario to apply, which is shown in the screenshoot, and this is my data table in power bi.
How can i acheive this please ?
Hi @Mamr ,
Based on your Data Table in power bi, not certain what is your expected output, what's the relationship between the data table and your needed picuture? Could you please consider sharing more details about this issue like your expected output based on the data table in power bi etc. for further discussion?
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @Mamr
add first a new column to your data with this formula to create a key for you columns
[Incident Type]&"-"&[Order Type]
Then use a matrix-visual to count the rows
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
I don't think anyone's going to be able to work this out without an explanation please.
There are extra data fields in the result and I can't see anything doing this -> "Apply grouping to get count of combination between 2 fields"
Also, please post data instead of a picture
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 |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |