cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Pimschoeman Frequent Visitor
Frequent Visitor

Line graph based on countifs

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.

test1.PNG

 

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 159 members 1,607 guests
Please welcome our newest community members: