i want to visualize in power Bi similar to Pivot Chart in Excel

[Um3rJalil]

Excel Pivot chart

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.

chart In power BI

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.

[Fowmy]

@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.

[Um3rJalil]

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.

[ryan_mayu · Accepted solution]

@Um3rJalil 

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