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 the following table
Aspect | Type | Software |
1.1 | A | XX |
1.2 | A | XX |
1.3 | A | XX |
1.4 | A | XX |
1.4 | A | XX |
1.1 | A | XX |
1.2 | B | ZZ |
1.2 | A | ZZ |
1.2 | A | ZZ |
2.1 | A | XX |
2.2 | A | ZZ |
2.3 | A | YY |
2.2 | A | XX |
2.1 | B | YY |
2.3 | A | YY |
1.1 | A | XX |
1.4 | A | YY |
2.2 | A | YY |
2.3 | C | XX |
1.3 | A | YY |
and I would like to filter this table with a measure, the filter can not be a page level filter. the filter must only show Type A.
then I should group every Aspect and count the amount for each Software. So the measure should throw a table somthing like this
Aspect | XX | YY | ZZ |
1.1 | 3 | ||
1.2 | 1 | 2 | |
1.3 | 1 | 1 | |
1.4 | 2 | 1 | |
2.1 | 1 | ||
2.2 | 1 | 1 | 1 |
2.3 | 2 | ||
Total | 9 | 5 | 3 |
Then I want to create a cake graph with 4 parameters (Yellow, Orange, Green and Blue) were the amount for each parameter have this following rule
Thanks
Solved! Go to Solution.
You may create measures to get the visual. Please refer to the attached sample file.
Regards,
Cherie
You may create measures to get the visual. Please refer to the attached sample file.
Regards,
Cherie
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |