Change series chart type in Power BI service

[Seer_Bug]

In power Bi service , I am trying to get a line chart with error% trend month on month . However apart from% of grand total , i am unable to find any other options.

As per the below example , Line chart should show :

Overall error % for Apr month for USA is 50% ( 2 error opportunity and 1 error made ) 

Overall error % for May month for USA is 100% ( 1 error opportunity and 1 error made)

Overall error % for Apr month for UK is 0% ( 1 error opportunity and 0 error made)

@amitchandak @v-xuding-msft 

I have a raw data like shown  below :  

Request number	Location/Site	Month	Error Opportunity	Error	Error%  = (error count _yes/error Opportunity)
1	USA	Apr	1	Yes	100%
2	USA	Apr	1	No	0%
3	UK	Apr	1	No	0%
4	USA	May	1	Yes	100%

[amitchandak · Accepted solution]

@Seer_Bug , Try like

DIVIDE(CALCULATE(sum(Test[Error Opportunity]),Test[Error] ="Yes"),CALCULATE(sum(Test[Error Opportunity])),0)

[Seer_Bug]

thanks @amitchandak . this worked.

1.however its not showing %, instead showing as 0.5 and 1.0. how do i get this as % ( I am new to PBI).

2.If I have multiple tables with similar data and if want to consolidate 4 tables with overall error % - how do i use a similar formula)

[amitchandak]

@Seer_Bug , Just like excel, if make it % type. It will display as % (*100). Or  multuple by 100.

As log as you have common dimesion and you do not have multiple number , you can do it easily. 

In case of multiplication you need to force row context. But that does not seems a need as of now.