Line graph based on countifs

[Anonymous]

Hello all, 

I'm relatively new to PowerBI, so i'm not really used to the DAX syntax yet, which is the reason i'm posting this question. 

Normally i make reports based on excel-made graphs. I am currently trying to reproduce a report in Powerbi. Most charts are working fine, but i have one graph i cannot seem to make. 

The problem:

I want to make a line graph with values based on multiple filters. An example of said line graph in excel.

The graph is based on a summary made out of a set of data consisting out of three columns:

columns(values)

Weekday (monday,tuesday,wednesday,thursday,friday)
type(Variable A, Variable B, Variable C)
Status(In use, Temporarily not in use, Not in use)
From this set of data i produced the following table:

                         Monday       Tuesday    Wednesday   Thursday   Friday

Variable A          45%                50%              41%            46%         38%
Variable B          36%                38%              27%            35%         20%
Variable C          13%                39%              23%            34%         %13

The formula i used to produce the summary above is:
used variables for example("Monday", "Variable A", "In use") 

=COUNTIFS(Data[Weekday];"Monday"
                    ;Data[Type];"Variable A"
                    ;Data[Status];"In use")

 /
  COUNTIFS(Data[Weekday]"Monday"
                    ;Data[Type];"Variable A")

From the summary i made the graph. I tried several things in powerbi, but i cannot seem to make it work. Can anyone explain to me how to produce the same graph in Powerbi?
Best Regards,

Pim Schoeman