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 all
I want to show a Pie chart
Dimension=Utilization staus Measure = No of Emp Id
Ex:
when I select week= 2/8/2019
when I select week= 2/8/2019 and Project = B
How can i achive this logic?
week | Emp id | Project | Utilization % | Utilization |
2/8/2019 | AVG_384 | A | 40 | Partially Utilized |
2/8/2019 | AVG_384 | B | 60 | Partially Utilized |
2/8/2019 | US_1 | A | 70 | Partially Utilized |
2/8/2019 | US_1 | B | 15 | Partially Utilized |
2/8/2019 | US_1 | C | 5 | Partially Utilized |
2/8/2019 | US_1 | D | 10 | Partially Utilized |
2/8/2019 | US_2 | B | 50 | Partially Utilized |
2/9/2019 | AVG_384 | A | 100 | Fully Utilized |
2/9/2019 | US_1 | B | 50 | Partially Utilized |
2/9/2019 | US_1 | D | 40 | Partially Utilized |
2/9/2019 | US_1 | E | 10 | Partially Utilized |
2/9/2019 | US_2 | E | 100 | Fully Utilized |
Solved! Go to Solution.
Hi @Anonymous ,
Based on my test, you could refer to below steps:
Create below measure:
Measure = CALCULATE(SUM(Table1[Utilization %]),ALLSELECTED(Table1[Utilization]))
Create visual and add related fields, you could see the correct result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Thanks @v-danhe-msft
I tried, but I can't achieve my scenario
Hi @Anonymous ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi @Anonymous ,
I could not understand your former sentense:
when I select week= 2/8/2019
when I select week= 2/8/2019 and Project = B
It seemed correct with my pbix, could you have downloaded it? I am confused about your requirements:
Pie chart want to show Partially Utilized=3
Could you please post your desired result picture if possible?
Regards,
Daniel He
Hi @Anonymous ,
Based on my test, you could refer to below steps:
Create below measure:
Measure = CALCULATE(SUM(Table1[Utilization %]),ALLSELECTED(Table1[Utilization]))
Create visual and add related fields, you could see the correct result:
You could also download the pbix file to have a view.
Regards,
Daniel He
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |