Dax help or advice for visual

[mespiritu]

I want to set up a line graph or bar chart with 12 added custom columns (Jul23 to May24) and only use "1" values to create the visual but not sure how to set it up. 

[mespiritu]

I followed those steps above and that created duplicates to my data.  The 1 and 0 indicate if the client ID was enrolled in the specific month and my goal is to count just the "1's" for each of the columns and put it on a graph or chart.

[mespiritu]

Hi to answer your question above - What does the "1" mean - it indicates that the client was enrolled in the month of the column (Jul23 - 1 = enrolled, 0 = not enrolled)

[Anonymous]

Hi @mespiritu 

What does the meaning of only use "1" values to create the visual?

Maybe you can use COUNT() function to get the number of the "1" in one day.

Here for your reference:

First of all, I create a set of sample:

In power query, Transform > Select all the columns and click the Unpivot Columns:

Close & Apply:

The result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.