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 am having a problem: I have several columns (reason1/2/3/4) where there can be 4 different values, in text format:
-Cold Food
-Smashed Food
-Rude Delivery
-Other
And each row represents a different order.
Not necessarily all the "reason" columns will have data.
-->Count: 3 "Colld Food"; 4 "Rude Delivery"; 4 "Other"; 5 "Smashed Food"
So, I want to count how many of each "complaint" exist, that is, that in PBI I want something like this:
My problem is that my idea is based on using "count", when adding it the numbers are wrong, that is, if I have two columns with data in a row, both are added. Example:
I only have two orders with a "Cold Food" complaint, but one of those orders also has "Rude Delivery", instead of showing a 2, I get a three because what i do is similar to:
CountOrder = count('Table'[Reason1])+count('Table'[Reason2])+ ......
Any help is welcome. Thank you
@CLQ for each value the reason is also will be in another column and whihc can be used as a parameter or slicer
Proud to be a Super User!
Oh, I think I understood. The problem is that my file is not the dataset, but it has a dynamic connection so I can't use PQ
In power query editor unpivot all reason columns and bring them into single column
Then try to use that in visual to get the requried visual
Proud to be a Super User!
I'm sorry, I didn't understand: if I have all the data in a single column, how would PBI recognize the four different texts and then count each one so that it looks like the graph I posted?
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 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |