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.
Hello,
I have a table with the following 5 columns:
Customer ID | Loan 1 | Loan 2 | Loan 3 | Loan 4 |
Cust1 | A | D | ||
Cust2 | B | A | C | D |
Cust3 | D | |||
Cust4 | B | A | D |
I have a slicer filter for the Loan where I can choose from the exisiting loans (A, B, C, D)
What I want to do is to show the total number of customers who have taken a particular loan (based on the slicer selection filter). For instance, if the user chooses Loan A from the filter, the card shows 3 or if the user chooses C, the card shows 1
Any help would be appreciated
Solved! Go to Solution.
@hamadani , Unpivot the 4 columns Loan1 -4 and then try to use the filter
https://radacad.com/pivot-and-unpivot-with-power-bi
@hamadani , Unpivot the 4 columns Loan1 -4 and then try to use the filter
https://radacad.com/pivot-and-unpivot-with-power-bi
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |