Dax help or advice for visual

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.

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)

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.