Producing a line graph with countifs

Anonymous — Tue, 09 Apr 2019 15:17:55 GMT

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

Re: Producing a line graph with countifs

v-evelk — Wed, 10 Apr 2019 15:22:39 GMT

Hello Pim Schoeman,

DAX is out of our expertise because it is a feature of Desktop so, it is more efficient to ask all the questions regarding DAX in the Desktop thread.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

topic Producing a line graph with countifs in Custom Visuals Development Discussion

Producing a line graph with countifs

Re: Producing a line graph with countifs