Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi i make this chart in Excel through Pivot Chart. in this Faults are on X-axis and i compared Before and After same fault.
Same Data i import in Power Bi and Then made measure to find the percentage of faults and then tried to make the same chart in Power BI just like Excel. but unable to get the same.
i need faults in X-Axis and compare before and after same as excel. i tried to put KNOT% in x Axis but it didn't allow me.
Solved! Go to Solution.
1. in the pq, select the first 5 columns and unpivot other columns
2. create a measure
Measure = sum(Sheet1[Value])/CALCULATE(sum(Sheet1[Value]),FILTER(all(Sheet1),'Sheet1'[Status]=max(Sheet1[Status])&&Sheet1[Attribute]="Inspected Meters"))
3. in the filter, select the attribute that you want to display
pls see the attachment below
Proud to be a Super User!
@Um3rJalil
Add the Status in the Legend section and the faults to be in the X-Axis,
Add you your measure in the Y-Axis.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Fowmy,
i tried but unable to do.
you can download the file from given link
https://1drv.ms/f/s!ArmINj1ERH_WjUNoMji-AOFft_Q5?e=UwwmET
hope to hear soon.
1. in the pq, select the first 5 columns and unpivot other columns
2. create a measure
Measure = sum(Sheet1[Value])/CALCULATE(sum(Sheet1[Value]),FILTER(all(Sheet1),'Sheet1'[Status]=max(Sheet1[Status])&&Sheet1[Attribute]="Inspected Meters"))
3. in the filter, select the attribute that you want to display
pls see the attachment below
Proud to be a Super User!
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |